Linking Access tables with SQL tables using File DSN through VBA

[pradeep.atta]

We have an ms access application and tables in that are linked with backend database SQL SERVER 2008

I used to manually link the access tables with SQL tables with the help of 'Table Link Manager' option. Now I want to do this programatically.

File DSN will contain belo information:

[ODBC]
DRIVER=SQL Server
UID=user1
PWD=password1
DATABASE=MyDB
APP=Microsoft Office 2005
SERVER=111.111.111.111,53314

My VBA code has to read this file DSN from the shared path and link the tables. Can you please provide the VBA code?

 

[mdlueck]

We have an ms access application and tables in that are linked with backend database SQL SERVER 2008

I used to manually link the access tables with SQL tables with the help of 'Table Link Manager' option. Now I want to do this programatically.

Sounds like you are in need of this solution:

Linked Table Saved Password ADOX code
http://www.access-programmers.co.uk/forums/showthread.php?t=226468#post1155700