Store database password in Access

[tom]

Hi All,

I have an access file which linked with an orcale database. Everything when
i query the file, I need to enter the id, pw & server name. Is there a way
to store my login information into access so that I dont need to login
everytime?

Thank you very much!!

 

[DanRoss]

Check the Save Password Box when you link your tables. . .

 

[tom]

Hi DanRoss

Thank you for your answering. I am using accecss 2003, when I link with the
table, it will ask me to login but there is no check box for me to save
password. Did I do something wrongly?

Thank you!

Tom

 

[Pat Hartman]

you need to delete the links and start from scratch. Refreshing doesn't
give you the option. If you still don't see the option, that may be because
your IT department has altered a registry setting. In that case, you can
add cod in your opening form to connect to a database. You would include
the password in the connection string.