>>>I have created a connection in a FoxPro DBC to an MS Access database. I have also created a Remote View in the DBC to connect a specific table. I perform a SQL-INSERT command into the remote view and then Tableupdate(.T.) and finally USE IN (RemoteViewName) to try and insure all is cleaned up and closed. It appears the remote view is updated while the app is running, but after I quit the FoxPro app the MS Access table remains unchanged.
>>
>>Did you mark RV to send updates to backend? Did you check return code from Tableupdate(.T.) ?
>
>
>Hi Sergey,
>
>I checked, and for some reason the option to send updates from this view to the backend MS Access database table is grayed out.
Have you specified a Key Field?