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
247 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS - Date Report Options 2 29
CDC and AOG on MS SQL 2012 13 25
SQL Error when trigger fires in SQL Server 2008 R2 6 16
Microsoft CRM 4.0 25 19
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
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 retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

830 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