Furthermore, by placing your connection string information in The Access Data Source differs from the Sql Data Source in one minor aspect - rather than specifying a connection string as with the Sql Data Source, the Access Data Source prompts for the path to the database file.Therefore, the screen shots above are different for the Access Data Source.
I have got a insert and select working as at the moment i have a page that shows the details on the page and then i want the user to change something then click update and then it would update the database and refresh the page with the new data.
Thanks Mike I set the field i wanted to change in the query without the parameter to 1 and it updated fine, the problem is that its not picking up my selected index properly!
The drop-down list lists existing connection strings defined in the , you have one place to update.
If not, you have to find each and every page that references the connection string and update it accordingly.
Your issue has nothing to do with the update itself.