Page 1 of 1
Access to Password protected Microsoft Access (mdb)
Posted: Thu 25 Jul 2013 07:01
by 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?
Re: Access to Password protected Microsoft Access (mdb)
Posted: Tue 30 Jul 2013 16:01
by Shalex
PatrickR_117 wrote:
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)?
Re: Access to Password protected Microsoft Access (mdb)
Posted: Sun 25 Aug 2013 07:36
by 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?
Re: Access to Password protected Microsoft Access (mdb)
Posted: Wed 28 Aug 2013 14:38
by 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.
Re: Access to Password protected Microsoft Access (mdb)
Posted: Thu 05 Sep 2013 09:08
by 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.
Re: Access to Password protected Microsoft Access (mdb)
Posted: Fri 06 Sep 2013 08:24
by 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