Store database password in Access

  • Thread starter Thread starter tom
  • Start date Start date
T

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!!
 
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
 
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.
 
Back
Top