Adlib home page > Support > Frequently Asked Questions

Why can't I edit or remove a certain record from a database?

If you can open a record, but you cannot edit or remove it, this is probably because a record lock was placed on that record. You will receive an error 34 or 85, and/or a message reporting that the record is in use or that no record lock can be applied. The record lock must first be removed before you can edit or delete the record.

When multiple users have simultaneous access to the same record, this may pose a problem. As long as the users only view information, nothing will happen. But multiple users cannot be allowed to change the same data at the same time. To prevent this, Adlib "locks" a record as soon as a user indicates that he wants to change this record. If another user then also tries to change this record, Adlib will prohibit this: after all, the record is locked. Adlib will only release a record when the changes have been saved. Such a lock is called a record lock, in Adlib.

In normal operation, Adlib cleans up a record lock as soon as a user stops editing the record, but if during editing of a record a malfunction occurs (e.g. a power failure or computer crash, but also when the pc enters sleep mode while a record is still in edit mode), it is possible that the record lock is not removed, and this causes an error when someone tries to edit the record again. In such cases, you can use the Record lock manager in Adlib Designer, or the separate Record lock manager tool, to check which records are still locked, and remove the record locks that are no longer applicable. Only remove a lock when you are sure that the record really is not being used!

(See the General topics: records locks topic in the Adlib Designer Help for information about how to use the Record lock manager. If Adlib Designer or the Record lock manager has been installed on your computer, you already have this Help file.)

The free Record lock manager can be downloaded here.