Link table via ODBC with VBA Code

[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.

 

[Alex Dybenko]

Hi,
here how to relink:
http://www.mvps.org/access/tables/tbl0010.htm

and here about DSNless connection:
http://www.accessmvp.com/djsteele/DSNLessLinks.html

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com