I am attempting to connect to an Access 2010 database using a Microsoft Data Link (a .udl file). I have password protected (encrypted) the Access 2010 databse.
Within the Data Link, I specify:
Provider: "Microsoft Access 12.0 Access Database Engine OLE DB Provider"
Connection: Data Source: <path><database name>.accdb
The password is entered under the "Use a specific user name and password section."
When I click the Test Connection button I get this message:
"Test connection failed because of an error initializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user."
Note: The Data Link worked fine before I password protected the database.
Anyone seen this before?
Within the Data Link, I specify:
Provider: "Microsoft Access 12.0 Access Database Engine OLE DB Provider"
Connection: Data Source: <path><database name>.accdb
The password is entered under the "Use a specific user name and password section."
When I click the Test Connection button I get this message:
"Test connection failed because of an error initializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user."
Note: The Data Link worked fine before I password protected the database.
Anyone seen this before?