How do I find the System DSN I created when trying to link to a SQL backend from the Linked Table Manager in Access?
My main work computer crashed yesterday and I'm trying to get things going on another computer in the office. One of my Access 2013 apps uses a SQL Server back end.
SQL Server is loaded onto the machine and I restored the backup of the SQL DB from the crashed machine onto on the new machine.
I also restored all of my Access projects, most of which use an Access FE and BE.
I had someone else set up the SQL Access link on the old machine but I'm tyring to work my way thru it, with out any success.
Here's what I've done:
I created a DSN within the ODBC Date Source Administrator. It is a System DSN named 'JTSDSN',
On the crashed machine the table were all linked to the SQL back end. On my new machine I open the front end accdb, then the linked table manager. I click the 'always prompt for new location' box, select all of the tables and click OK.
At that point I'm presented with a 'Select Data Source' box. This selection box has two tabs 'File Data Source' Machine Data Source', not 'System Data Source. The default location is the 'MyDocument' folder but my DSN is not shown there. What directory do I have to navigate to, to find my DSN. When I created the DSN I was given the opportunity to select the location where it was created, so it went wherever the default location is.
Any help or suggestions in getting this linked will be appreciated. This is all unproductive time and have deadlines approaching on this application.