ADO Jet 4.0 & Access Db with password

Alberto Ibarra

Delphi Developer

Sat, 15 Jan 2005 04:58:39 GMT

ADO Jet 4.0 & Access Db with password

I have an Access DB and I'm using ADO using oledb provider for Jet 4.0. If
this DB does not have password set everything works OK but as soon I set a
password to this DB I get this error:
"Cannot start application. The workgroup information file is missing or
opened exlusively by another user".

I have no idea what does it mean. If I use ODBC no problem but ODBC is
slower that Jet for accessing Access Databases.

Thanks in advance

Albert Ibarra

Brian Bushay Team

Delphi Developer

Sat, 15 Jan 2005 10:01:04 GMT

Re:ADO Jet 4.0 & Access Db with password

Quote

>I have an Access DB and I'm using ADO using oledb provider for Jet 4.0. If
>this DB does not have password set everything works OK but as soon I set a
>password to this DB I get this error:
>"Cannot start application. The workgroup information file is missing or
>opened exlusively by another user".

You have to provide the password in the connection string.
Is this a Database password or a use level password?
If it is a database password you need to set the
"Jet OLEDB:Database Password" property.

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Other Threads

1. Installing MS Jet 4.0 OLE DB for ADO use

2. MS Jet 4.0 - Can't connect to Access 2000 db

3. Querying dates in ADO/Access/Jet 4.0

4. Record locking with ADO - Delphi 5 and Access 97/2000 - Jet 4.0

5. OLE DB Provider for ODBC OR Microsoft Jet 4.0 Ole DB Provider

6. Access 97 MDB file - ADO Jet 4 OLE DB

7. Setting an Access DB Password with ADO

8. ADO, JET OLEDB 4.0 AND ODBC

9. How to seek (ADO->JET 4.0)

10. ADO with JET 4.0 too slow...