OLE DB provider '%ls' reported an error. %ls
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
Step 1) Register your MDW or MDA location for your MDB file
If your Access database is secured, and uses an MDW or MDA workgroup/security file to store user access, you will need to modify the registry on the SQL server to find the corresponding MDW or MDA file required by the MDB you are trying to link.
Complete documentation can be found here:
Step 2) Create the Linked Server
Here is an example of the script you will need to run to create the linked server.
Complete documentation on the sp_linkedserver command can be found here
This script can be found by logging into SQL Management Studio, and going to
In the template explorer window, expand SQL Server Templates>Linked Server
Double-Click on Add Linked Server access MDB
-- Add Linked Server Access MDB template
@server = N'AccessTest',
@provider = N'Microsoft.Jet.OLEDB.4.0',
@srvproduct = N'OLE DB Provider for Jet',
@datasrc = N'C:\dbs\test\dailylog.mdb'
-- Set up login mapping using current user's security context
@rmtsrvname = N'AccessTest',
@useself = N'TRUE',
@locallogin = NULL,
@rmtuser = 'Admin',
@rmtpassword = null
Once the above script has been run, you should be able to run each of the following to confirm if your link works correctly.
-- List the tables on the linked server
EXEC sp_tables_ex N'AccessTest'
-- Select all the rows from the Customer table in the linked server
SELECT * FROM AccessTest...customer