Opening a secured Access DB 2

[colobill]

I have a VB6 app that is using Microsoft Access 2000. I opened the database in exclusive mode and set a password. In the VB app I am trying to open the database. I am using the following syntax:

Dim ADOConn As New ADODB.Connection
ADOConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & App.Path & "\ABC.mdb", , "password".

When I run the VB app I get the following error message:

"Cannot start your application. The workgroup info file is missing or open exclusively by another user".

What am I missing? Any help would be appreciated.

 

[SonOfEmidec1100]

I think this is what you need

ADOConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" _
           & "Data Source=" & App.Path & "\ABC.mdb;" _
           & "Jet OLEDB:Database Password = 'password';"

 

[colobill]

Thank you. That did the trick.