Archived Content: This information is no longer maintained and is provided 'as is' for your convenience.
Novell NetWare 5.0
Novell NetWare 4.11
Novell NetWare 3.2
Novell NetWare 3.12
MS Access 97
Maximum File Locks (default: 10000, range 100-100000)
Maximum File Locks Per Connection (default :250, range 10 - 1000)
Formerly TID: 2935504
Record lock threshold exceeded
Station x record lock threshold exceeded. Total violations #####
Error: MM-DD-YY HH:MM:SS PM: SERVER-4.11-679 Station x record lock threshold exceeded. Total violations #####.
The error may also include the following line: Severity = 0 Locus = 11 Class = 19
Errors can occur on the server console when starting MS Access applications.
MS Access heavily uses file and record locks in the database files and the default limit per connection (NW4.11: 500) is exceeded very easily. In Microsoft documents Q173006 and Q102522 there is reference that Access 97 will default to using up to 9,500 record locks before starting another transaction (or issuing an 'Error 3052 - File Sharing lock count exceeded' in an Access dialog box).
Applying NW5SP3a or later for NetWare 5 will change both the "Maximum File Locks..." parameters on the File Server to: Maximum File Locks Per Connection (default: 2500, range 10 - 10000)
Maximum File Locks (default: 200000, range 100 - 2000000)
Here are the SET-parameters you need to modify: (the default values are for NW4.11)