Oops! Didn't check "Save password" when linking tables. What now?

[Jo]

I'm a newbie, using Access 2003 to pull data from an ODBC data source. When I
initially linked the tables using the Link Table wizard, I didn't notice the
"Save password" checkbox in the wizard. I linked about 20 tables, and since
then I've spent a few weeks developing queries and reports, always putting in
the password whenever prompted, which was annoyingly frequent.

I just learned that I could have checked the "Save password" box when
originally linking the tables. Is there any way I can add the password now? I
tried deleting some of the linked tables and re-adding them, which worked for
a few, but for most of them I get an error message saying that the linked
table cannot be deleted because of relationships. It asks if I want to delete
the relationships too, but I afraid to say Yes for fear of messing up the
queries and reports that I spent so much time building.

I tried the Link Table manager but it does not offer that Save password
checkbox when re-linking.

Can anyone offer a way out of my fix? Thanks in advance.

 

[Arvin Meyer [MVP]]

Delete the links and start all over.

 

[KenSheridan via AccessMonster.com]

It can be done by amending the Connect property of each linked tabledef
object, but Arvin is right; just deleting the all links and recreating them
with the wizard is far simpler. Your queries and reports won't be affected,
but you should still back up the file beforehand, just in case!

The relationships in the back end file to which you are linking, which are
the important ones, won't be affected either. Relationships in the front end
serve little purpose other than setting the default joins when you create
queries.

Ken Sheridan
Stafford, England

 

[Jo]

Gotta love an easy fix! Thank you both.