ODBC Password

[Gerry]

I have an application that accesses an ODBC database. The database is
readonly and the application works great. I want to enable the application to
run on it's own but I have to be there to enter the password each time.
I am prompted for a company code, user id and password.
How can I work around this?

Gerry

 

[Albert D. Kallal]

Delete that linked table, and re-create it.

When you're re-linking the table make sure you check the box to remember the
person's password that occurs during that process. If you check that box,
then you not need to enter a password.

 

[Tom Wickerath]

Albert,

Your advice *may* be okay if the connection requires only a generic readonly
account, but even that may be questionable. If the credentials required are
those of a particular individual, then checking the option to remember the
password is likely to attract unwanted attention from the company's security
department. Checking the option to remember a password could easily be an
offense that would send a person home for several days without pay at my
place of work.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________