Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Microsoft Data Link (.udl) problem

Status
Not open for further replies.

hyarmion

Technical User
Dec 23, 2008
20
AU
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?
 
Correction to the above post, the database I am attempting to connect to is an Access 2007 one, not Access 2010, but that was just a typo, the problem remains.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top