We have a MS Access database with 15 users running on Novell 3.2 server. The main form for input into the database uses "Record Locks = Edited Records".
We have come up with problem were a user will edit a record, close out of the form and another user or the same user with enter the form and same record a few minutes later and get a record lock violation.
The Maximum Record Lock Per Connection on the Novell server is set to 1000. We have tried lowering this and Sation Violations start to appear on the server.
Is there any way to force a release on the record locks MS Access is causing on the Novell Server?
Thanx
We have come up with problem were a user will edit a record, close out of the form and another user or the same user with enter the form and same record a few minutes later and get a record lock violation.
The Maximum Record Lock Per Connection on the Novell server is set to 1000. We have tried lowering this and Sation Violations start to appear on the server.
Is there any way to force a release on the record locks MS Access is causing on the Novell Server?
Thanx