Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem linking tables for good.

Status
Not open for further replies.

mbcmike

Programmer
Sep 9, 2005
34
US
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top