Using an encrypted MDB

  • Thread starter Thread starter Anil Gupte
  • Start date Start date
A

Anil Gupte

I am using an MDB file which I have secured using the Access 2000 security
wizard. When I try to open it using a VB program I get an exception saying
"Cannot start your application. The wrokgroup information file is missing or
opened exclusively by another user". However, I can open it manually by
double-clicking on it and using the userid and password. I am using this
string to open it.

ConnStrMDB = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry
Path=;User Id=" & strUID & ";Password=" & strPWD & ";" & _
"Jet OLEDB:Database Locking Mode=1;Data Source=" & MDBFile & ";Jet
OLEDB:Engine " & _
"Type=5;Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:System database=;Jet
OLEDB:SFP=False;persist security " & _
"info=True;Extended Properties=;Mode=Share Deny None;Jet OLEDB:Encrypt
Database=False;Jet OLEDB:Create System " & _
"Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet
OLEDB:Compact Without Replica Repair=False;" & _
"User ID=Admin;Jet OLEDB:Global Bulk Transactions=1"
ConnWizoMDB = New OleDbConnection(ConnStrMDB)
ConnWizoMDB.Open()

What am I doing wrong?

TIA,
 
if you crerated a new workgroup information file ( that is the only true
secure way of a password protected encrypted access database )

your connection string should be like this

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=pathtodb\mydb.mdb;Jet
OLEDB:System Database=pathtomodified\YourSystem.mdw;User
ID=myUsername;Password=myPassword;

HTH

Michel
 
Are you using non-ENglish locale by any chance. In that case Jet engine does
not work. It is a known issue. I had this problem earlier. I had set kannada
as my language/locale. Jet engine was failing. When I set it back to English
it worked. It took nearly three months for me to figure out his bug.

-Pavanaja
 
Back
Top