link table using dao and odbc connection to sql server 2K

[emmanuelbeaudet]

I have a application with some tables linked on SQL server 2K enterprise edition using DAO. All work perfectly, but each time the applicaton needs to access the database it ask for the login and the password to access the database.
Is that possible to enter the login and password just one
time ?
The user and password is set in the odbc connection.

Thank you.

 

[PHV]

with some tables linked
In the link table manager check something like remember password.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244