Link table via ODBC with VBA Code

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

Guest

Ok ... I used to have this but can't locate any of my own samples -- arghh!!!!

I need to link tables in Access to a SQL server without referencing a
prebuilt ODBC connection - with VBA code when the MDB file is first opened.

I have a table containing the tablenames (source & destination) that I'll
use to define the links.

I've tried the TrasferDatabase method with the acLink option but it is
expecting a pre-build ODBC resident on the computer running the app.

I need to get around that ... any assistance would be greatly appreciated.
 
Back
Top