dear all,

how would i access a password-protected Access database using ADO?

thanks in advance.

best regards,

carlex

put tje loginprompt := false;
in the login event of the adoconnection set the username and the password;

"carlx" <carlex.cre...@spectrum.ph> schrieb im Newsbeitrag
news:3d2a848f$1_1@dnews...

thanks.

That depends if you are using a database password or user level passwords.

For database password you set the "Jet OLEDB:Database Password"
Property

For user level passwords you set the "Password" property and the
 "Jet OLEDB:System database"
which is the location of your .mdw file

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com