Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

SQL Server 2012 - Access 32-bit 2003 - I can import the database, I don't understand why I can't link to it. SQL 2012 may have changed the connection string or something.

I just installed SQL Server 2012 to test differences and make sure it is ok for my Work. I may not be a pro at SQL, but I don't see how to add a Link to Jet database on my server. I have imported Jet Databases, but when going thru the GUI to Link a JET Database I see no Provider for JET. I am running Access 2003 (I don't like the 2008+ GUI)

I searched an found nothing similar to my issue; at least nothing I understood. Nothing mentioned how to add Jet db Provider.

I ran a connection string to the Jet Database thru QA:

sp_addlinkedserver 'USGEScrub', 'Access', 'Microsoft.Jet.OLEDB.4.0',  

The connection string works till I try to access the data and then I get this the error and of course if I click the links nothing shows up:

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click:


An exception occurred while executing a Transact-SQL statement or batch. Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "USGEScrub". (Microsoft SQL Server, Error: 7302)

For help, click:

share|improve this question

looks like it might be to do with the drivers.
Here is Microsoft's take on the issue:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.