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:
Expand|Select|Wrap|Line Numbers
- [ODBC]
- DRIVER=SQL Server
- UID=user1
- PWD=password1
- DATABASE=MyDB
- APP=Microsoft Office 2005
- SERVER=111.111.111.111,53314