Delphi and a password protected access database

[XGAEREC]

Hi
I use Delphi 7 and MS-Access for an application. I have protected database using a "database password".
But I don't succeed to open the so protected database from Delphi. I use a connection
string similar to <Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\PostazioneDatabase\DBMessaggi.mdb;Mode=Share Deny None;Extended Properties="";Persist Security Info=False;Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDBatabase Password="";Jet OLEDB:Engine Type=5;Jet OLEDBatabase Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDBon't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False> to connect the database and obviously I obtain error (i must give password).
But if I write password in the connection string, I obtain an error saying "information file "Il file di about job group is not found or open from another user in exclusive mode".
The question is : how can I do to open the protected database from Delphi (I repeat database access is protected by a password database

Thank you

Gaetano Recchi

 

[Gigatech]

I use the following connection string and it works fine:


procedure TfmData.DataModuleCreate(Sender: TObject);
const
ConnStr = 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s;Persist Security Info=False;Jet OLEDBatabase Password=MyPassword';
begin
ADOConnection1.Close;
ADOConnection1.ConnectionString := Format(ConnStr,[ ExtractFilePath(ParamStr(0))+'MyDataBase.mdb' ]);
ADOConnection1.Open;
end;