username in adp

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

 

[andrei skor]

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]

answers in english please

 

[Sylvain Lafontaine]

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.