Log into Database automatically

[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

 

[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.

 

[[MVP] S.Clark]

In a DSN you can store the userid & password.

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

 

[Jaz]

It only ask for the username, not the password.

In a DSN you can store the userid & password.

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