Howdy, Stranger!

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

Categories

ODBC Linking

dcreswelldcreswell Member Posts: 2
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.

Thanks,
David Creswell
Sign In or Register to comment.