It's funny, we both replied with the same ideas but in reverse order. You proposed to review the views first and then mentioned TableUpdate while I did in the other way around. :)


>>Hello all,
>>I'm tring to get y VFP6.0 application to update an Access MDB.
>>With the Database open, I've created views of the tables that I want and the fields that I want the user to see.
>>
>>How to I get these " remote views" to actually update the access tables
>>
>>I've tried the SQL"commands" such as sqlcommit() etc.
>>
>>Can I use VFP commands to make changes on the records in the views and can I then send them to the Access tables??
>
>Did you make the views updatable? In the view designer, on the Update Criteria tab, make sure you have identified the Key Field, check all the other fields you want updated and check the send SQL updates box. Then all you have to do is issue a TableUpdate() to send the changes back to MS Access.