General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Curt,
Do you have 'Send SQL updates' selected in the 'Update Criteria' tab of the remote view? Check that you also have the fields selected in the 'Update Criteria' for updating.
It's then a matter of issuing a tableupdate() or closing the view to update the data in the Access table(s).
Hope this helps,
Gavin...
>I need to update a Microsoft Access data file. I have created the connection and a remote view in my project, but can't update the data base with the commands I am used to. The updates only occur on the view, not the actual Access database. When I reopen the view, the old data is still there. What commands are needed to update the actual Access data file.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only