change the database password (Access)

  • Thread starter Thread starter Guest
  • Start date Start date
¤ ok, ya got me, how do I change the database password via code?

You can use ExecuteNonQuery with the following:

"ALTER DATABASE PASSWORD " & "new_password" & " " & "old_password"

You will need to add the following to your connection string in order to open the database for
exclusive use (required when changing the database password):

Mode=Share Deny Read|Share Deny Write


Paul
~~~~
Microsoft MVP (Visual Basic)
 
thanks,
the part I was having trouble with was the exclusive lock
Mode=Share Deny Read|Share Deny Write
Seems to work now
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 10 W10 password prob. 2
?? Changing a MUST_CHANGE Password ?? 6
Re set new tablet computer with lost password 1
how to identify the OleDb exception without relying on its message 1
Lock the navigation pane 0
Cannot update Access Database 10
Expiration notification 4
login/password C# and access. 9

Back
Top