Linked tables - save password

[SerenityNet]

I created a bunch of linked tables, but did not check the "save password" box. Is there a way that I can enter and save my password with the linked table now, or do I have to create them all over again from the start?

 

[Pat Hartman]

You can try refreshing the links with the linked tables manager. Check the box at the lower left of the form to force the re-link. If that doesn't give you the option, you'll need to delete the links and do them again. Or you could write code to update the connect string. Unless you are fluent with VBA, the delete and relink will be the simplest solution.

 

[SerenityNet]

What / where is the linked tables manager?

In my DB tables view, I see the globe icons for the linked tables. If I open the tables then I'm prompted for my username and password, but there is no option to save them.

 

[SerenityNet]

Thanks for the help. I just recreated the linked tables and it is working.

Andrew