Link table via ODBC with VBA Code

B

Bob Bonta

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I get a Shareable URL via VBA code to a OneDrive image? 0
Working outlook via vba code with xlsx - error 0
Link from SQL server 1
Creating a table link via ODBC in another ACCESS database 1
Setting Primary Key on a Linked SQL Table 4
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
OpenDatabase with ODBC 1
Select Unique Record Identifier 2

Top