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
EFS
0
Reputation points
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?
1 answer
Sort by: Most helpful
-
Tom van Stiphout 1,621 Reputation points MVP
2024-04-23T23:57:01.24+00:00