Change Database password?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe - 09 Nov 2006 19:07 GMT

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?

Reply to this Message

Joe - 13 Nov 2006 15:53 GMT

I know this isn't much help - but I was wondering what type of application
are you creating where you let the users change passwords on something that
the DBA normally does?

> Hello all,
> I am trying to find a way to change an access database password at run
[quoted text clipped - 14 lines]
>
> Can anyone give me a few pointers please?

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...