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?
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?