J
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.
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.