Linked Table manager

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have just installed Access2003 - The VBA code I use to link tables in
Access2000 no longer works and when I manually try to use the link table
option and select ODBC as my file type nothing happens - when I run
Access2000 it works fine. The Access2003 Book I have said I should be able
to do it. what am I doing wrong.

The VBA code I have been using is as follows

DoCmd.TransferDatabase acLink, "ODBC", strConnectionString, acTable,
strTableName, strTableName, False
 
According to Help, it should be "ODBC Database", not just "ODBC".

Check Access 2003 VB Help on the TransferDatabase Method. There is a sample
code using "ODBC Database".
 
Back
Top