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
File DSN will contain belo information:
APP=Microsoft Office 2005
My VBA code has to read this file DSN from the shared path and link the tables. Can you please provide the VBA code?