Enter Query Password Automatically

[jereece]

I have a Access query that I run on linked tables. Access to the data on the linked tables requires an ID and Pasword. For my situation, both ID and Password are "pipread". Is there a way I can make my query enter this password automatically so that I don't get prompted for it? This ID / password never changes.

Thanks for the help.

Jim

 

[NJudson]

This is just a wild guess because I have no idea how to do something like that with a query but, I'm wondering if you code write a little code that would do the following:

Sub RunQuery
DoCmds.SetWarnings(False)
DoCmd.RunQuery.......
DoCmds.SetWarnings(True)
End Sub

This very well may not work since your dealing with a linked table, but it may be worth a shot.

Good luck

 

[jereece]

No....simply turning off the warnings won't do what I need. The linked tables require the UserID and Password (pipread) to be viewed, so any query I use to access the data will prompt me for the UserID and Password. I am just looking for an automatic way to enter these.

Thanks....

Jim

 

[Pat Hartman]

Delete the link to the table and then recreate it. You should see the checkbox option to save the password.

Another method (one you would need to use if the user needed to supply the user id and password) is to open a connection to the db containing the linked table as part of the start up process for this db.

 

[jereece]

Deleteing the link to the table and then recreate it and select remember password worked. Thanks!