Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 262
  • Last Modified:

In SQL Server 2008, I am receiving an error whenever I try to access any linked server based on a mdb or xls file

I am getting the error:

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "LA_CITIZENS_CURRENT_ACCESS_DB" returned message "Unspecified error".
Msg 7303, Level 16, State 1, Procedure loadMonthlyMDBData, Line 38

Whenever I try to create a linked server based on an Office product like an Access database or Excel spreadsheet.  It doesn't seem to matter whether the file is local or on the network.  Linked files have been working fine for months until today.  Had to restart SQL Server a couple of days ago, not sure if that makes a difference.  Linked Servers connecting to other databases seem to be working fine
0
sheafsu
Asked:
sheafsu
  • 4
  • 3
  • 2
1 Solution
 
RiteshShahCommented:
Can you please drop your linked server and create it again with the steps I have provided in my below article.

http://www.sqlhub.com/2009/03/linked-server-in-sql-server-2005-from.html
0
 
nmcdermaidCommented:
Can you copy the MDB or Excel file to a computer which has Excel or MS Access installed, and try opening it with Excel/Access. It may give you a better error message.
Why did you restart the SQL Service?
0
 
RiteshShahCommented:
nmcdermaid,

I have doubts about excel/access file, I wonder if it not corrupted.
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
nmcdermaidCommented:
Yes, thats why you need to copy it somewhere that has Excel or Access and try opening it there.
0
 
nmcdermaidCommented:
Sorry, thought you were the original poster.
0
 
Mark WillsTopic AdvisorCommented:
Could be a permissions thingy, is there anything else different other than restarting the services e.g. updating Office ? Have shares or permissions changed especially for the SQL services owner (ie the account used to start and run those services) ? Is it only linked servers using Jet ?
0
 
RiteshShahCommented:
mark_wills,

we are in blind so far that is why I suggested to check whether files are not corrupted and create linked server again so that if proper steps follows while creating the linked server again, permission error could be resolved.
0
 
Mark WillsTopic AdvisorCommented:
Yep, but is was working...
0
 
nmcdermaidCommented:
Thats why I wanted to know why he restarted the service originally - was it to change the logon account perhaps?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now