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.


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.


Database query in MS Access is unacceptably slow.

NetWare MONITOR shows an excessive number of record locks.


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


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.


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.


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.