Revision Date: 2005-12-13
Problem:
The following error was reported by a GAGEpack customer who had a GAGEpack database (which is a Microsoft Access database) on a Novell Netware shared drive:
Couldn't update; currently locked
Solution:
This error message could occur with any PQ product that opens an Access database, such as SQCpack, CHARTrunner, and GAGEpack.
If this error occurs when the Access database is located on a Netware shared drive, and does not occur when the Access database is located on a non-Netware drive (such as a local computer drive, or a Windows server share) then often the problem is related to the number of record locks permitted by the Netware server.
If you watch the monitor on the Netware server you may see that is says something about record lock threshold exceeded.
Have your Netware system administrator increase the number of record locks available per connection and per server.
Typically this can be done by adding or adjusting these two commands in the servers' autoexec.ncf. The actual values used should be chosen by your Netware system administrator for your version of Netware.
SET MAXIMUM RECORD LOCKS PER CONNECTION=10000
SET MAXIMUM RECORD LOCKS=100000
The commands can also be run from the system console prompt first to avoid a server restart.
