Linked Server connection Problem

From: Alan Z. Scharf (ascharf_at_grapevines.com)
Date: 01/19/05 

Date: Wed, 19 Jan 2005 11:42:54 -0500

SQLServer2000
Access 2000
Windows Server2003

1. I had a Linked Server to an Access 2000 database which had worked for two
months.

2. Hoever, now when I execute queries againt it in Query Anayler, e.g.

    SELECT * FROM LINKEDSERVERNAME...TableName

The query Analyzer just says "Executing query batch" and stays there for
several minutes. No error messages. Pressing red button to end query puts
QA into 'Progran not responding mode'. No error messages in QA.

3. If I go to Linked Server in EM and click on Tables or Views, most of the
time I get same thing - i.e. just hourglass for minutes.

Somtimes in EM when I click on Linked Server Tables or Views, I get Error:

Error 0: SqlDumpExceptionHandler:Process 51 (or 55) generated fatal
exception 0000005 EXCEPTION_ACCESS_VIOLATION. SQLServer is terminating this
process.

4. Only one time, time in EM, when clicking on Linked Server Tables, I got
Error 7339:OLE_DB Provider Microsfot.Jet.OLEDB reported an error.

5. I tried finding answers to this in Google, but to no avail.

Any help would be appreciated. Thanks.

Alan