Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC Linking

Status
Not open for further replies.
dcreswell

dcreswell

Technical User
Jul 7, 2006
2
US
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
 
Status
Not open for further replies.

Similar threads

PercyNK
  • Locked
  • Question
Error linking mysql to ms access 2010 front-end
Replies
1
Views
96
PercyNK
PercyNK
abenitez77
  • Locked
  • Question
odbc error with passthru
Replies
8
Views
75
lameid
lameid
tnguyen315
  • Locked
  • Question
how to execute stored procedure from access vba using DAO with trusted connection, ODBC, DSN = 'DTe' 3
Replies
9
Views
550
tnguyen315
tnguyen315
Halliarse
  • Locked
  • Question
Connection string - ODBC failure
Replies
2
Views
75
vbajock
vbajock
stephenmbell
  • Locked
  • Question
VBA - Create Pass Thru Query without ODBC DSN??
Replies
5
Views
166
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top