ADO & Access -- permissions, groups, password problems

[rlb_wpg]

Q1
I am trying to connect to an access database with a password.
This is the error I receive:
Test Connection failed because of an error in initialize provider.
Cannot start your application.
The workgroup information file is missing or opened exclusively by another user.

Q2
I have connected to an access database (without a
password) and receive the following error when I try
and open a table:
-2147217911
Microsoft Jet Database Engine Record(s) can't be read;
no read permissions on 'Clients'

Can anyone help?


I am not having luck today!

[alexmac]

Yes I got this message. I never figured out how to connect with different user groups etc but this connection string works using just a db password.

connection string:

Set conn = New Connection
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=yourdb.mdb;Persist Security Info=False;Jet OLEDBatabase Password=" & dbpassword

Hope this helps

Alex