Unanswered: CreateTableDef and Unique Record Identifier
When I link a foxpro 2.5 table using CreateTableDef, it creates a read only link. If I add the link from Access it promts me to select the Unique Record Identifier. Is there a way to select this in my program?
Set tbl = db.CreateTableDef("employee", 0,"employee"), "odbc;dsn=fox
You should be able to find out more about the parameters in the help. I have found it helpful to writ ea macro to do it, then use the macro to help you with the parameters in the VBA code. It can be a little confusing when you are trying to determine the source and destinations because the same method is used to Import Link and Export a table or file.