Board index » delphi » Problem connecting to a secured Access2000-Database with ADO

Stephen Hahn

Delphi Developer
Sat, 11 Sep 2004 06:30:22 GMT

Problem connecting to a secured Access2000-Database with ADO

Hello all,

does anyone know how to connect do a secured Access 2000 Database
with ADO using a MS-Jet 4.0 OLE DB Provider Connection.
The Error-Message: Cannot find the information file of the Workgroup.
I secured the Access-DB and there is an .mdw in the same directory.
Even this doesn't work:
Provider=Microsoft.Jet.OLEDB.4.0;User ID=Test;Data Source=C:\test\Test.mdb
/WRKGRP "C:\test\Test.mdw";Persist Security Info=False

Thanks
Stephen

 
DRS

Delphi Developer
Sat, 11 Sep 2004 06:50:10 GMT

Re:Problem connecting to a secured Access2000-Database with ADO


Quote
"Stephen Hahn" <stephen.h...@t-online.de> wrote in message

news:3c9fa4ff$1_1@dnews...

Quote
> Hello all,

> does anyone know how to connect do a secured Access 2000 Database
> with ADO using a MS-Jet 4.0 OLE DB Provider Connection.
> The Error-Message: Cannot find the information file of the Workgroup.
> I secured the Access-DB and there is an .mdw in the same directory.
> Even this doesn't work:
> Provider=Microsoft.Jet.OLEDB.4.0;User ID=Test;Data Source=C:\test\Test.mdb
> /WRKGRP "C:\test\Test.mdw";Persist Security Info=False

If it's secured then presumably there's a password.

Jet OLEDB:Database Password=MyPassword;

--

Quidquid latine dictum sit, altum viditur.
#319

Lee-

Delphi Developer
Tue, 14 Sep 2004 23:15:21 GMT

Re:Problem connecting to a secured Access2000-Database with ADO


Hi,

Never tried it my self, but I think you should add something like "Jet
OLEDB:System database=C:\test\test.mdw" in the connection string.... or
maybe use an odbc dsn and specify the mdw in it (if odbc is an option for
you)?

Lee-Z

Quote
"Stephen Hahn" <stephen.h...@t-online.de> wrote in message

news:3c9fa4ff$1_1@dnews...
Quote
> Hello all,

> does anyone know how to connect do a secured Access 2000 Database
> with ADO using a MS-Jet 4.0 OLE DB Provider Connection.
> The Error-Message: Cannot find the information file of the Workgroup.
> I secured the Access-DB and there is an .mdw in the same directory.
> Even this doesn't work:
> Provider=Microsoft.Jet.OLEDB.4.0;User ID=Test;Data Source=C:\test\Test.mdb
> /WRKGRP "C:\test\Test.mdw";Persist Security Info=False

> Thanks
> Stephen

Other Threads

1. connecting a password secured Access2000 database

2. database update problem with D6 ADO/VCL, ADO v2.6, and MS Access2000

3. connecting a password secured MSAccess Database

4. Connecting to a secured database

5. Password issue in ADO & MS Access2000 Database

6. ACCESS2000 and BDE5.01 connecting problems

7. problem connecting to 'secure' Access DB

8. ACCESS : Problem with "secure database"

9. Connecting D2 to Access2000 - how?

10. enable to connect to access2000