How to connect to Secure DB (using ADO) as a current user?

[surotkin]

Hello,
Does anybody know how to connect to a Secure DB (User-Level Secured) using ADO as a current user?

The problem is: I can get the user's ID, but I cannot get the user's password that is necessary to set Connection to the Secure DB.

Any help appreciated.
Surotkin

 

[PHV]

So, you want to connect to an User-Level Secured DB without knowing the password ?

 

[Ed2020]

You'll need to prompt the user to enter their password as part of your procedure. If MS provided a way to circumvent this in VBA is would defeat the object of user level security.

As a separate issue if I'm working with Access databases I avoid using ADO except in rare circumstances when ADO provides a preferable way of working. ADO is much slower when connecting to Access/Jet databases than DAO. Even MS advise DAO is faster.

Ed Metcalfe.

Please do not feed the trolls.....

 

[surotkin]

PHV,
not exactly.
I want to allow a user to connect to an User-Level Secured DB without specifying the password every time. User specifies the password (which is stored in MDW-file) in the beginning of the Session. I don't think it is a good idea to ask the user for password again, since he/she did it once.

Ed2020,
Thanks for your comments.
I will keep it in mind.

Surotkin