Problem with linking tables 1

[mbcmike]

I am using Access 2003.

Someone sent me an Access mdb file through email. When I open it on my end and try to get into one of the linked tables, it says connection failed. So obviously I use the linked table manager and put my username and password in and I'm good to go.

However, when I exit the mdb, and try to go back in, I have to do this whole process all over again because I can't get into the linked tables. The linked table manager keeps prompting with the username and password of the last person who had this mdb. I'm assuming there is a way for someone to force the file to want their username and password each time it is accessed? If so, how do I take this off?

 

[mbcmike]

Ah shoot...I posted this in wrong forum.
To admin: please delete this, Ill repost in access forum

 

[nickspace]

When you link tables using linked table manager, check the box that reads "Save Password".

Nick

 

[mbcmike]

Again...I apologize for posting in wrong forum...but since someone replied....


I don't see "save password" when I click linked table manager. What I would really want is for it to not save password I would think anyway...so that it doesn't keep forcing a username and password.

 

[nickspace]

My apologies.... linked table manager does not have a save password option. Here's what you'll need to do:
1) Delete all linked tables
2) Right-click on tables and select link tables
3) Find the correct DSN
4) Input the username and password
5) While selecting the tables from the available tables, check the "Save Password" box (near the bottom right corner).

HTH.