Database query in MS Access is unacceptably slow.

  • 10025255
  • 1.0.49636454.2492291
  • 20-Jan-2000
  • 12-Dec-2001

Archived Content: This information is no longer maintained and is provided 'as is' for your convenience.

Fact

Novell Client 4.7 for Windows NT/2000

Novell Client 3.3

Novell Client 3.1 with SP1 or SP2.

MS Access 97

Novell NetWare 5.0

Novell NetWare 4.11

Access database resides on a NetWare legacy volume.

MS Access is installed locally on the workstation.

Query time is reduced drastically if unpatched 3.1 client is installed.

Microsoft client for NetWare does not exhibit the problem.

Symptom

Database query in MS Access is unacceptably slow.

NetWare MONITOR shows an excessive number of record locks.

Cause

Change made to SP1/SP2 causes delays due to the method the updated client is handling record locking.

Fix

Fixed with NWFS.SYS dated 19 November 2001or later, written for the 4.81 client version.  As of this writing this patch can be found in the download file  274666.exe.

Cause

Another cause could be Virus Software holding on to files prior to releasing them.  In one scenario the problem was with Norton Antivirus 2001. Without the Antivirus loaded the PC took approx. 14 sec to open the file.  With Norton loaded it took between 2 to 4 min.

Fix

Create a test workstation and apply only the OS (i.e. Win95/98 or WinNT/2000) and perform a "vanilla" install of the Novell Client.  Apply the software apps one at a time until the problem reoccurs.  This will isolate which application is causing the problem and can then be addressed accordingly.