-
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!
-
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 OLEDB:Database Password=" & dbpassword
Hope this helps
Alex
