I’m using VFP 6.0 and I have a function that Imports Access data into a dbf free table. What I want to do now is update the Access table with any changes that were made to the dbf table by my app. I have a separate table that has stored all of the original Access field names and the field names used by FoxPro in case they had to be modified.

My connection is established with Access via gnConnHand=SQLSTRINGCONNECT(lcConnString) using lcDSN = "MS Access 7.0 Database" and not a specific Named Data Source.

The Knowledge Base article Q138094 "How to Create Updatable Views by Using SQL Passthrough" gives an example of what I think is suppossed to work for me but nothing works. The example and documentation are very vague. No matter what I do I get a message saying "No update table specified. Use the tables property of the cursor" and no matter how I enter the table name with =CURSORSETPROP("Tables", ctablename) I still get the same message. Trying other tactics hasn’t worked either. Most of the time things go with out crashes but the table is never updated.

Does anybody have any experience with this type of SQL (ie SQLSetProp(), CURSORSETPROP(), etc.) or whatever it takes to update a "foreign" table such as Access?

Any help would be appreciated.

Ed