How to automate MS Access to set Password

[Diego2000]

Hello Labview Help:

I'm trying to automate the setting of new password in Microsoft Access 2003 or 2007 Database Application.

in Labview Activex or Visual Basic. 

Here is where the NEW password would be written.

It would be great if you can help or point me to the right place.

I tried looking at MSDN info, but quite complicated.

The hardest part is how to navigate to the other objects within Microsoft Access with Activex.

thank you,

diego2000

[PhillipBrooks]

If you have the DatabaseConnectivity Toolkit and an open connection to the DB, you should be able to use an Execute Query to modify the password.

http://msdn.microsoft.com/en-us/library/bb177884(v=office.12).aspx

ALTER USER user PASSWORD newpassword oldpassword

[Diego2000]

Hi Phillips:

Yes, I have the Database Connectivity Toolkit.

I will try the command and will report back. It should work.

thanks,

Diego2000

[Diego2000]

Hi Phillip:

I have tried what you sugested. Getting close but getting an error.

Looks like I'm missing a file?

I have also tried the "ALTER DATABASE PASSWORD new1 old1" following command:

Thanks for your help,

diego2000.

[PhillipBrooks]

The link I provided had a comment at the bottom stating that the db should be opened exclusively with a mode=12 connection string option. Maybe that would address the error you received.

[Diego2000]

Phillip:

This is how I'm opening the Access Database. Where would I write the mode=12   ?

Where would I write the "mode=12" ?

Provider=Microsoft.ACE.OLEDB.12.0;Persist Security Info=False;Data Source=C:\New3.mdb

thank you much,

diego2000

[PhillipBrooks]

Should be able to add Mode=12; to end of string...

From the link:

OleDbConnection objOleDbConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=Sample.mdb; Mode=12");

[Diego2000]

Thanks Phillip:

I'll try to convert to a Labview statement.

diego2000

[Diego2000]

Phillip:

On second thought, how would you change the password of Access with Visual Basic or VBA?

I'm downloading Visual Basic now.

thanks,

diego2000