You need to issue a TableUpdate() to commit changes from the views to the actual tables. You can evaluate the result of TableUpdate() to see if you changes were indeed commited.

Also, make sure you have "Send Updates" check mark checked on the view designer. Finally, ensure you have defined the primary key in the view.

>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??
>
>Thanks
>
>Sandy