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.