I want to setup a connection on a VB6 DataEnvironment using Microsoft Jet 3.51 OLE_DB Provider for an MS Access 97 database which is password protected.

Here are the steps I follow:

1. Right-click on Connection1 and select Properties to see the Data Link Properties Dialog.

2. Select Microsoft Jet 3.51 OLE DB Provider and press the Next button

3. Select the MS Access database using the elipses button.

4. Specify "Admin" for User Name and a password for Password.

5. Press the Test Connection button only to recieve the following error:

Microsoft Data Link Error: Test connection failed because of an error in initializing provider. Can't start your application. The workgroup information file is missing or opened exclusively by another User.

If I remove the password from the database, I do not have any problems.
If I try connecting using OLE DB Provider for ODBC Drivers, I have no problem even with a password protected database. I can't do away with the password because my client needs it.

I tried MSDN with the following suggestion:

"Can't start your application. The workgroup information file is missing or opened exclusively by another user. (Error 3028)


To ensure referential integrity in databases created by the Microsoft Jet database engine, your application must read the Microsoft Jet database's System.mdw file. Make sure the file is in the location specified in the SystemDB value of the \HKEY_LOCAL_MACHINE\ SOFTWARE\ Microsoft\ Office\8.0\ Access\ Jet\3.5\ Engines\Jet key in the Windows Registry."

My computer registry setting is OK.

I am using WinNT4, VS6 with SP3.

Thank You.