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
sheafsuAsked:
Who is Participating?
 
RiteshShahConnect With a Mentor Commented:
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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
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
All Courses

From novice to tech pro — start learning today.