>>>>>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?
>
>John,
>
>Thanks! It's been ages since I worked with Views and Connections. I inherited this app and the database, and didn't know what the key field(s) was/were. For now I have guessed at the most logical field and all seems OK, now my buttons are non-gray and I can send updates.
>
>Thanks again,
You're Welcome