Microsoft KB Archive/109400

From BetaArchive Wiki
Knowledge Base


ACC: README.TXT File and Novell Locking Issues

Article ID: 109400

Article Last Modified on 5/6/2003



APPLIES TO

  • Microsoft Access 1.0 Standard Edition
  • Microsoft Access 1.1 Standard Edition
  • Microsoft Access 2.0 Standard Edition



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.

Keywords: kbsetup kb3rdparty KB109400