Using an encrypted MDB

[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 OLEDBatabase 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 OLEDBon'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,

 

[Michel Posseth [MCP]]

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

 

[Pavanaja U B]

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

 

[Anil Gupte]

Thanx, that works great!