An Access 2000 database may stop responding when you open the database in a multi-user environment (827425)



The information in this article applies to:

  • Microsoft Access 2000

This article applies only to a Microsoft Access database (.mdb).

Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

When you open an Access 2000 database in a multi-user environment and then you run Trend Micro antivirus software on your computer, the Access database may stop responding. If you use Windows Task Manager to try to end the task that corresponds to the database, you may receive the following error message:
This program cannot be closed. If it is being debugged, please resume it or close the debugger first.

CAUSE

The Trend Micro scan engine software scans all the types of files in the scan list. The scan engine of the antivirus software may take longer to scan large Microsoft Access database files (.mdb) than other types of files. If you try to close the Access database file while the file is being scanned, you may receive the error message that is mentioned in the "Symptoms" section.

RESOLUTION

To resolve this problem, remove the .mdb files from the scan extension list or remove the .mdb files from the Trend Micro Scan Engine software virus scan.

For additional information about how to turn off scanning for the affected versions of Access database files, visit the following Trend Micro Web site:

MORE INFORMATION

In a multi-user environment that has the Trend Micro Scan Engine software installed on the computers, your client computers may experience slow performance when you try to open the Access 2000 database file and you try to open the Access 2000 database objects. However, if you install Microsoft Office 2000 Service Pack 3 on the client computers, the performance may improve.

The performance may also improve if you try to open the Access 2000 database by using the Network Scan Switch (Netscan.exe) utility. Netscan.exe is a command-line utility. Netscan.exe works in conjunction with Trend Micro OfficeScan Corporate Edition 5.0. Trend Micro OfficeScan Corporate Edition 5.0 is the Trend Micro antivirus software. Netscan.exe can turn the network real-time scan feature of OfficeScan clients on and off. Netscan.exe accepts the on parameter or the off parameter as the input parameter and then switches the network scan correspondingly, as in the following examples:
  • To turn on the OfficeScan client Network Scan function, run the following command from the command prompt:
    netscan on 
  • To turn off the OfficeScan client Network Scan function, run the following command from the command prompt:
    netscan off
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

Modification Type:MajorLast Reviewed:12/15/2003
Keywords:kbDatabase kbPerformance kberrmsg kbprb KB827425 kbAudDeveloper