username in adp

  • Thread starter Thread starter Everaldo Ricardo
  • Start date Start date
E

Everaldo Ricardo

using mdb, when a user open the mdb file and put his username and password,
the windows keeps username for next time...

but...

using adp, the username's default always is the connection's username

how can I change this situation?
 
Everaldo Ricardo said:
using mdb, when a user open the mdb file and put his username and password,
the windows keeps username for next time...

but...

using adp, the username's default always is the connection's username

how can I change this situation?
Click to expand...
 
You must use Integrated Security or Close/Reopen the connection; something
like:

CurrentProject.CloseConnection
CurrentProject.OpenConnection connectionString, user, password

Not a perfect solution, I admit.
 
Back
Top