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