In the LTM I check the SQL data source, click Relink, and the Edit Connection String dialog appears.
It should have an explicit "DATABASE=" section, as shown here.
If that is missing, the default database will be used, which could be the "master" database.
ODBC Connection DSN and Linked Table Manager Giving Different Results: The link table manager in access database only gives the master tables
I am setting up a DSN and a Linked Table Manager link all on the same Access database on the same computer with the same database Login and associated User (and of course the same database). The DSN gives me the tables I need, but the Linked Table Manager does not, it only gives me the Master tables, what am I doing wrong?
3 answers
Sort by: Most helpful
-
Tom van Stiphout 1,696 Reputation points MVP
2024-04-23T23:57:01.24+00:00 -
EFS 25 Reputation points
2024-05-24T14:58:16.3166667+00:00 So I figured this out. When you are in LTM a second window pops up asking for which server and the credentials you are asking for. You need to select the "Options" button. This will give you a second chance to select which database you are actually trying to connect to. Now you will see all of your custom tables in the DB you have selected. It's very strange that even though you paste in the server URL, the DB, and the credentials in the LTM custom SQL connection string that it doesn't recognize any of it and makes you select everything all over again. Very strange.
-
EFS 25 Reputation points
2024-05-24T16:30:56.28+00:00 After you add the custom connection string into LTM a popup window appears asking you to reenter the URL and credentials - here is where you need to click on the Options button where you can select the default database. It doesn't care what you put in the connection string, it uses the drop down in the extended form instead - then your tables appear.