How to creat user and set password to Access Database?

[bigbigsong]

Right now, i can only open an acess database file using password if it has. But I wonder how to set user and password to the database file? Thanks!

[wiebe@CARYA]

It's not clear what you want to do.

Connect with a used ID and password? Create constants for the user ID and password input.

Protect the database with a password? Google, it's an Access question, not a LabVIEW question.

[bigbigsong]

Sorry, I mean is there a way to set the password of .mdb file dynamicly? If i creat a .mdb file and want to set a password to it.

NI Database Tool Kit has a way to access .mdb file with password protected, but no way to set the password. Thanks!

[wiebe@CARYA · Accepted solution]

See this post (VB).

Apparently you need to execute the query:
"ALTER DATABASE PASSWORD [newPassword][OldPassword]"

More info on MSDN (ALTER USER or DATABASE Statement).

[bigbigsong]

Thank you so much!