Linked Tables

[darkwing75]

Hi! How do you automate the installation of a System DSN? Because we are trying to deploy an application with an MS Access frontend and a SQL server backend and it is a pain going to each PC in the company to put the System Data Source, thanks!

 

[ByteMyzer]

A very good example of how to do this can be found at the following link:
Tables: Creating DSNs from code

Alternatively, you can make a modification in the Connection String for each table link to the SQL Server Backend. If your Connection String is something like this:
[tt]ODBC;DSN=MyDSN;Database=MyDatabase;Server=MyServerName;...[/tt]
...you can change it to:
[tt]ODBC;Driver={SQL Server};Database=MyDatabase;Server=MyServerName;...[/tt]

With the second method, there is no need to install System DSN's for every front-end installation.