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 derfloh 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
Joined
Jul 7, 2006
Messages
2
Location
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 Question
Error linking mysql to ms access 2010 front-end
Replies
1
Views
208
PercyNK
PercyNK
abenitez77
  • Locked
  • Question Question
odbc error with passthru
Replies
8
Views
306
lameid
lameid
tnguyen315
  • Locked
  • Question Question
how to execute stored procedure from access vba using DAO with trusted connection, ODBC, DSN = 'DTe'
Replies
9
Views
798
tnguyen315
tnguyen315
Halliarse
  • Locked
  • Question Question
Connection string - ODBC failure
Replies
2
Views
188
vbajock
vbajock
stephenmbell
  • Locked
  • Question Question
VBA - Create Pass Thru Query without ODBC DSN??
Replies
5
Views
436
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top