access database password problem

[DavidMaidman]

Hi,

I currently have an application where configuration settings are stored in a MS Access Database which I access using the Database Connectivity Toolkit. This all works fine, however I now need to apply a password to database.

I have applied a password to the database in Access however when I try and connect I get the error code -2147217843 and a message saying 'the workgroup information file is missing or opened exclusively by another user....'. I have tested the connection using the Data Link editor and get a similar error.

I'm using LabVIEW 8.5.1

Windows7

Jet 4

any thoughts?

[camerond]

[Caution - Bias showing]

I don't know what your error code -2147217843 means, but I would strongly suggest that if you do not have a lot of time and effort invested in Access that you drop it like a hot potato and find another to use. I was using Access several years ago with a Perl DBI front end and found that it had so many nonstandard idiosyncrasies that I was spending all my time changing standard SQL to Access. MySQL and PostgreSQL are good, mature products, and a bunch of other RDB programs have popped up since them, may be good, I don't know, I just continue to use MySQL.

[Back to LabVIEW stuff]

Cameron

[DavidMaidman]

Access is a customer requirement.

I don't think that this is a LabVIEW issue as I get a connection error when I test in the UDL data link program.

I have had a colleague test this and he has the same problem so I think it is an Access quirk. I am using Access 2013 and my colleague is using 2007.

If anyone else is successfully using a password protected access database with the database connectivity toolkit please let me know.