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
[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]