Linked Tbl Mgr behavior

[Russ]

When I want to link tables to the front end using the link tables
manager it willl ask me to select the back end for each and every
table wheras in prior versions of Access I only had to make this
choice once if I checked the box "always prompt for new location".
This is tedious. I'm using Access 2007 Enterprise version.

 

[John W. Vinson]

When I want to link tables to the front end using the link tables
manager it willl ask me to select the back end for each and every
table wheras in prior versions of Access I only had to make this
choice once if I checked the box "always prompt for new location".
This is tedious. I'm using Access 2007 Enterprise version.

I've seen this happen if the links aren't all to the same backend. Yes, it's a
pain! What I'll sometimes do is just delete all the links in the frontend, and
use External Data... Link to create new links.

If all of the linked tables have links to the same backend, this (usually)
isn't necessary.

--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[Russ]

I think that is it. I had a couple of testing backends and
inadvertently one of the links was pointing to a table in a different
db. It took me awhile to see it among all the table locations, but I
finally got it going.

 

[Tony Toews]

I think that is it. I had a couple of testing backends and
inadvertently one of the links was pointing to a table in a different
db. It took me awhile to see it among all the table locations, but I
finally got it going.

FWIW I now have code that on startup goes down the tabledefs and
compares the connect string. If any differences it displays an error
message along with the offending details.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/