Change Database Password?

J

Joe

Hello all,
I am trying to find a way to change an access database password at run
time in VB2005.
I open the connection to the database as shown below:

objConnection = New OleDbConnection( _

"Provider=Microsoft.Jet.OLEDB.4.0;" & _

"Data Source=" & AppPath & "MyDatabase.mdb" & ";" & _

"Jet OLEDB:Database Password=" & DBPassword)

and it works well. I have created a button on the form to enable the user to
change the database password but I am having a problem figuring out how to
actually change the password at run time.

Can anyone give me a few pointers please?

Thanks
 

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

Macro doesn't work any more 0
'ALTER DATABASE PASSWORD' does not work for me 1
Data source 0
Connection String problem 1
Exporting data with vba from Excel to an Access 2007 db with password 8
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
can not find installable ISAM 1
Get results from Access Database. 2

Top