Access to Password protected Microsoft Access (mdb)

[PatrickR_117]

We are currently trying to secure some of our local databases (Microsoft Access ; *.mdb).

But connection strings like

Code: Select all

provider=MS Access;Data Source=<FILENAME>;Password=TESTTEST

didn't worked.

Connecting to a mdb file without a password worked without a problem.

We are using "Devart dotConnect Universal 3.20 Pro 115".
We tried to switch the provider and different other things - nothing seemed to work.

Do you happen to have some lines of code showing how to connect to a protected MS Access database?

[Shalex]

But connection strings like

Code: Select all

provider=MS Access;Data Source=<FILENAME>;Password=TESTTEST

didn't worked.

1. Specify the exact text of the error you are getting and its call stack.
2. Does it work if you are connecting to the database directly via Microsoft OLE DB provider for MS Access (not via dotConnect Universal)?

[PatrickR_117]

1. Devart.Data.Universal.UniConnection.Open() is the source.
"Cannot start your application. The Workgroup information file is missing or opened exclusively by another user."
AND I'm absolutely sure there was no other connection to this file open!

I tried modifications of the connnectionstring (include "uid=admin" etc.) ... nothing worked.

2. It works without any problems with OleDBConnection ...

Code: Select all

Dim mConn As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<SOURCE>;Jet OLEDB:Database Password=<PASSWORD>;")
mConn.Open()
Dim mCmd As New System.Data.OleDb.OleDbCommand("select * from <TABLE>", mConn)
Dim da As New System.Data.OleDb.OleDbDataAdapter(mCmd)
da.Fill(dset)

Any suggestions?

[Pinturiccio]

We have reproduced the issue with dotConnect Universal. In our environment the issue is reproduced with System.Data.OleDb as well. We will investigate the issue and post here about the results as soon as possible.

[Pinturiccio]

We have fixed the bug with the Database Password connection string parameter.
In the new version of dotConnect Universal you will have to replace the connection string:

Code: Select all

provider=MS Access;Data Source=<FILENAME>;Password=TESTTEST

with:

Code: Select all

provider=MS Access;Data Source=<FILENAME>;Database Password=TESTTEST

We will post here when the corresponding build of dotConnect Universal is available for download.

[Pinturiccio]

The new build of dotConnect Universal 3.40.486 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/univer ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=27867