ADO connection with password to Access DB

G

Guest

I'm using the following code to connect to an access 2000
database.
(with reference to adodb
Public DBvar As New ADODB.Connection(
DBvar.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=Data.mdb", "userID", "Pass"

Previously I was connecting with jus
DBvar.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=Data.mdb")
and it was working fine because I had not set a password
for the database. Then I set a password and now using
DBvar.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=Data.mdb", "Admin", "Pass"
and I get this error
"Cannot start your application. The workgroup information
file is missing or opened exclusively by another user.
When I set the password I had to open the database file
exclusively for it to set it. Does that have anything to
do with it
What does this error mean? How do I fix this

Thank yo

Se
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Connecting to ADO database 5
Connect to a password protected MS Access DB 2
Connection String Help 2
Error with automated execution 5
access connection 3
Insert statement using ADO with Access DB and SQL DB 2
Connection String Problem 6
ADO.Net and FoxPro 8 dbf file 4

Top