Are you able to link a table from the database in question into your database, open the table and see the contents just fine?
If so you may just have mistyped your DSN.
Also, is the DSN you're using a SYSTEM or USER DSN, that could make a difference as well.
Can you show the code you're using to connect to the database?
I have a database with linked tables to the SQL Server through the DSN. I could open the tables before but now I cannot.
The DSN is perfect because I can open the ODBC manager and test the connection and it succeeds.
The DSN is a System DSN.
There is not code to show, these are simply linked tables.
Ok. I found the answer.
There are two ODBC Data Source Administrators, they are located at:
- C:\Windows\SysWOW64\odbcad32.exe
- C:\Windows\System32\odbcad32.exe
If you go to: Start > Control Panel > Administrative Tools > Data Sources (ODBC)
You will get the odbcad32.exe found in C:\Windows\System32
If in Access 2013 (64 bit) you go to: External Data > ODBC Database
You will get the odbcad32.exe found in C:\Windows\SysWOW64
Neither of these ODBC Data Source Administrators shows you all of the DSN on your machine.
If you want to edit a DSN you created using Access (64 bit) you will have to launch
C:\Windows\SysWOW64\odbcad32.exe from the command line and there you will get the
option to edit the DSN created through Access.
I hope this saves someone else the pain I have gone through for two days.
Ha yes I've run into this myself, particularly when dealing with different versions of MS access but I was going for the easy stuff first.