database password update from Labview

[myanmar]

Hi, Is there anyway to update (change) microsoft access database password from Labview program? Right now I am using ODBC DSN to access my database. By using database connectivities tool kits, I can  access to database using user ID/password on database Open VI. But there is no VI which can change database password. Any idea? or any example VI? Please help me. THanks

[Dennis_Knutson]

The toolkit is based on ADO which is a generic database interface and the toolkit uses standard SQL commands for the database queries. I don't think there exists a command in SQL to change a password. I suspect that password changes would be unique to each database provider (ie. SQl Seriver, Oracle, Jet). You might want to look through the ActiveX properties and methods of Access. MSDN is probably a better place to check.

Just, curious, but why do you need to change passwords?

[myanmar]

Thanks for your reply.

Why I want to change password is that we have many database, so each database have different password. Everytime when user connect to database, they will have to type in password to access database. Also there will be option for user to modify the database password by using labview program without going in to microsoft access database.

[Jared_B]

myanmar,

I also believe your best bet would be through ActiveX.  I am not sure what version of access you are using, but this article might be a good resource to start looking.