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)
Click to expand...
 
Top