Solved

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

Posted on 2009-05-05
9
246 Views
Last Modified: 2012-05-06
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
Comment
Question by:sheafsu
  • 4
  • 3
  • 2
9 Comments
 
LVL 31

Accepted Solution

by:
RiteshShah earned 500 total points
ID: 24311585
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
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 24311591
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
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24311621
nmcdermaid,

I have doubts about excel/access file, I wonder if it not corrupted.
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 30

Expert Comment

by:nmcdermaid
ID: 24311650
Yes, thats why you need to copy it somewhere that has Excel or Access and try opening it there.
0
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 24311653
Sorry, thought you were the original poster.
0
 
LVL 51

Expert Comment

by:Mark Wills
ID: 24311907
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
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24311956
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
 
LVL 51

Expert Comment

by:Mark Wills
ID: 24312909
Yep, but is was working...
0
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 24320583
Thats why I wanted to know why he restarted the service originally - was it to change the logon account perhaps?
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Sql Server group by 10 29
SQL - Copy data from one database to another 6 19
Separate 2 comma delimited columns into separate rows 2 32
sql server service accounts 4 26
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question