I get it done. The statement is <br>
<br>
Set mDBPIS = db.OpenDatabase("\PIS.MDB", False, False, "MS Access;PWD=philip")<br>
<br>
<br>
Thanks the help from everybody.<br>
No. I access the database through opendatabase with path and MDB file name. It works when there is no database password created. I try to use the workspace default password but it doesn't work. <br>
<br>
Thanks for your reply.<br>
<br>
<br>
Hi, <br>
<br>
I use database password to protect an Access database from unauthorized access as it is easier to manage compared with the user level security. However, I cannot open the database from VB and get an error message of 'Invalid password'. <br>
<br>
Thanks in advance for any help.<br>...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.