Access to Password protected Microsoft Access (mdb)

Access to Password protected Microsoft Access (mdb)

Postby PatrickR_117 » Thu 25 Jul 2013 07:01

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?
PatrickR_117
 
Posts: 2
Joined: Thu 25 Jul 2013 06:35

Re: Access to Password protected Microsoft Access (mdb)

Postby Shalex » Tue 30 Jul 2013 16:01

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)?
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Re: Access to Password protected Microsoft Access (mdb)

Postby PatrickR_117 » Sun 25 Aug 2013 07:36

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?
PatrickR_117
 
Posts: 2
Joined: Thu 25 Jul 2013 06:35

Re: Access to Password protected Microsoft Access (mdb)

Postby Pinturiccio » Wed 28 Aug 2013 14:38

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
Devart Team
 
Posts: 1979
Joined: Wed 02 Nov 2011 09:44

Re: Access to Password protected Microsoft Access (mdb)

Postby Pinturiccio » Thu 05 Sep 2013 09:08

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
Devart Team
 
Posts: 1979
Joined: Wed 02 Nov 2011 09:44

Re: Access to Password protected Microsoft Access (mdb)

Postby Pinturiccio » Fri 06 Sep 2013 08:24

The new build of dotConnect Universal 3.40.486 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/universal/download.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
Pinturiccio
Devart Team
 
Posts: 1979
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect Universal