🚀 go-pugleaf

If you have password on database level, use "Jet OLEDB:Database password"
property without User ID and Password. If you use .mdw file, set its
location in "Jet OLEDB:System database" property.

Do not construct property this way. Build string and assign
ADOQuery->ConnectionString only once.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Chri" <chrip@libero.it> �������/�������� � �������� ���������:
news:4148027c$1@newsgroups.borland.com...
> I tried to open a protected db in this manner:
>
> ADOQuery->ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;";
> ADOQuery->ConnectionString = ADOQuery->ConnectionString
> +"SystemDatabase=MUR.mdw;";
> ADOQuery->ConnectionString = ADOQuery->ConnectionString +
"Password=pippo;";
> ADOQuery->ConnectionString = ADOQuery->ConnectionString + "User
ID=pippo;";
> ADOQuery->ConnectionString = ADOQuery->ConnectionString + "Data
> Source=MUR.mdb;";
> ADOQuery->ConnectionString = ADOQuery->ConnectionString + "Persist
Security
> Info=False;";
>
> I have MUR.mdb and MUR.mdw in the program folder! An error occour at the
run
> time with the message that it doesn't find the information file (i think
> it's .mdw)... I don't know how to do, i've protected my db and i want to
> access it with my password!!!
>
> Thanks, Chri.
>
>