Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View to Access 2007 table doesn't update data
Message
 
 
To
04/04/2011 09:35:22
George Lechintan
Independent consultant
Sebes, Romania
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01506005
Message ID:
01506007
Views:
43
You have to make view updateable on Update Criteria tab

>
>I'm doing this very simple test:
>- create a new project
>- add a dummy database
>- create a Remore View to a table in an Access 2007 database using the folowing connection string
>"DSN=Mdb;DBQ=c:\test\data\project.MDB;DefaultDir=c:\test\data;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;"
>- browse the view
>- modify data
>- save
>- tableupdate()
>- close database
>
>No errors happen but data in Access is not updated.
>
>Did anybody try this before ? Any help is welcome.
>
>Thank you.
>
>-gl
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform