SQL Server 2K Linked Access 97 Server not working

D

David Kirkman

An Access 97 linked server in SQL Server 2K has recently stopped
working. In Enterprise Manager, the following error message appears
when attempting to view the list of tables in the linked server:

Error 7399:OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005: ].

This linked server has not been used recently and in that time Win2K
SP4 and SQL Server 2K SP4 have both been applied. We now need to use
this linked server on a regular basis so any help will be much
appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link Access to SQL 2000? 0
Error 7399 When trying to link an Access database to SqlServer 2K 1
Trouble with the ACE provider 0
Problem with linked server from SQL Server to Access 2003 database 2
Linked Server Problems 1
Linked Server 1
Sql Server 2000 linked server to Access 97/2000 incompatability 1
Problems with ACE OLEDB provider 1

Top