ACC: README.TXT File and Novell Locking Issues (109400)



The information in this article applies to:

  • Microsoft Access 1.0
  • Microsoft Access 1.1
  • Microsoft Access 2.0

This article was previously published under Q109400
Moderate: Requires basic macro, coding, and interoperability skills.

SUMMARY

The README.TXT file shipped with Microsoft Access version 1.1 contains a section titled "Using Microsoft Access on Novell NetWare Servers and Banyan VINES Servers (Increasing the Number of Record Locks)". This information does not apply to Novell NetWare286 (version 2.x). It only applies to Novell NetWare386 (version 3.x) and Banyan VINES.

The README.TXT file does not state that the information does not apply to Novell NetWare286.

MORE INFORMATION

The following information is taken from the README.TXT file:
 ------------------------------------------------------------
 Using Microsoft Access on Novell NetWare Servers and Banyan
   VINES Servers (Increasing the Number of Record Locks)
 ------------------------------------------------------------

 On Novell NetWare Servers:

 If you are attempting to use large Microsoft Access databases on a
 Novell NetWare server, set the "maximum record locks per connection"
 to the largest allowable value (10,000). The execution of large bulk
 operations in Microsoft Access (such as a large update query) can
 cause the server to run out of record lock connections. If you do not
 set the number of record locks to the maximum value while using
 Microsoft Access, it could result in the loss of data due to a server
 crash.

 See your Novell NetWare documentation for a description of
 how to set the number of record locks.
 ------------------------------------------------------------
				

NOTE: NetWare286 does not have definable configurations for its locking schemes. A server supervisor can use the NetWare console command FCONSOLE to view the locks on the network.

The third-party products discussed here are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.

Modification Type:MajorLast Reviewed:5/6/2003
Keywords:kb3rdparty kbsetup KB109400