>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.
Mark McCasland
Midlothian, TX USA