Linked table manager - "Select data source" multiple times

B

BizProcessesTech

Attempting to relink all tables using a standard SQL ODBC. But, when
choosing all tables in Linked Table Manager (LTM) and choosing 'prompt for
new location', the "Select data source" dialog box appears for each table in
the Access app. So, instead of choosing the DSN one time for all tables, I
am reprompted to select the DSN for each table that it is attempting to
relink. Something has happened to this .MDB file and I cannot, for the life
of me(!), determine why I am re-prompted for each table. As you know,
selecting a DSN for each table is very time consuming.

This is a very clean install of both Access and SQL (2 seperate boxes).
But, this just started happening out of the blue on one of my development
Access DB's.

Thanks for MVP input ASAP.
 
M

[MVP] S.Clark

This happens, typically, when you have checked the "Always prompt for new
location" checkbox, which is in the bottom left of the dialog box. Try to
not use that and see if it runs better for you.
 
Top