Can't Write to FoxPro Linked Table

G

Greg

I have an Access database that links to FoxPro tables. If I link the tables
manually (File - Get External Data - Link - ODBC - etc), everthing works
seamlessly, but if I use VBA (setting Connect and SourceTableName properties
of a new TableDef) I can link to the tables but lose write functionality. I
do notice that the manual linking asks for a Unique Record Identifier, but I
don't know of any property that I can set in VBA that would do the same
thing. What can I do in VBA to get write functionality to the linked FoxPro
tables?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sqlite-odbc write conflict 2
Linked Foxpro tables not editable? 0
Importing FoxPro 2.6 DBF Into Access 2007 1
Problem Linking Foxpro 9 .DBC in Access 2003 7
How do I use OLEDB to link to a Visual FoxPro file 1
Can't link to FoxPro db 1
Visual FoxPro via ODBC, #Deleted records, yet works in Excel 1
Linked Tables from FoxPro Database using an OLE DB connection 0

Top