Log into Database automatically

J

Jaz

I have an access program that uses a ODBC Link to another database. I use
it to pull certain information out of our ERP system.

When I first start it, it always ask to for a userID and password to connect
to our ERP database.

Is there a way to program access to automatically enter in the required
information so I don't have to enter it in everytime?

Thanks,
Jasper
 
V

Van T. Dinh

Usually, you should be able to set the password in the DSN (Data Source
Name) being used to establish the linked Tables.

Check the DSN you use an see if there is any option to set the password.
 
M

[MVP] S.Clark

In a DSN you can store the userid & password.

Start / Control Panel / Administrative Tools / Data Sources (ODBC)
 
J

Jaz

It only ask for the username, not the password.


[MVP] S.Clark said:
In a DSN you can store the userid & password.

Start / Control Panel / Administrative Tools / Data Sources (ODBC)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top