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
244 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
 
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
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

895 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now