Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fails to update the Remote View MS Access table
Message
From
29/07/2007 15:57:37
Irv Adams
MSC Managed Care, Inc.
Florida, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01244432
Message ID:
01244464
Views:
12
>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform