I am linking foxpro odbc tables to an access database through vba. For each table, I get a prompt to select a unique record identifier. This would be ok for a couple of tables, but I could potentially have thousands of them. Is there any way to programmatically bypass this prompt if I knew the unique identifier at runtime?
I am using the following code to link the tables...
DoCmd.TransferDatabase acLink, "ODBC Database", strConn, acTable, strTable(i), strTable(i), 0
Any help is appreciated.