ODBC Linking

Hello everyone:

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.

David Creswell
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!