Microsoft Access Security

[Novatronics]

What is the trick to setting of the security on a Microsoft Access Database?  I would like to send the user name and password using the “DB Tools Open Connec (Path).vi” or setting the password in the “file.udl”.  I am trying to prevent the user from just opening the database with Access 2002 and changing information.

[AESulzer]

Are you asking how to set up security on an Access database or are you asking how to connect to a protected Access database from LabVIEW? If it is the former, I would recommend taking a look at the Microsoft Access help.

[Novatronics]

I am having troubles with both ends.  I change the permissions in Access and then cannot open the database in Labview.  I am not sure what setting on both sides to use as well there is the .udl file that also has a password line.

I am just confused and therefore at this point have no security on the database.

Thanks,

Paul

[AESulzer]

In LabVIEW, all you have do is wire the appropriate username and password to the associated inputs on DB Tools Open Connection.vi. Is this what you are doing? If so, what error messages are you getting, or rather how is it not working? Also, how are you setting the security up in Access?

Kind Regards,