You and Another User are Trying to Edit the Same Action

You and Another User are Trying to Edit the Same Action

PROBLEM

  • You and another user are trying to edit the same action

CAUSE

This error is most likely begins with a network issue of some kind that resulted in a corrupted record being stored in the database. At that point, the Microsoft database engine then locks that corrupted record so that another user appears to be using it at the same time.

SOLUTION

To fix this error, run the Gorilla database utilities “Database Fixer” and “Database Compactor”.

In almost all cases, this will correct the problem. Use the instructions on the knowledgebase article How to use the Database Analyzer and Database Fixer and How to Compact the Gorilla 4.x Database for information on how to run these utilities.

Sometimes, though, it may not be possible to run those utilities because of the nature of the locked record. In that event, perform the following steps.

Please note: these steps, while easy to follow, do require a working knowledge of file management in Windows.

  1. Make sure no one is running the Gorilla program. Everyone must be out of Gorilla before continuing with these instructions.
  2. Click on Start>Computer and navigate to the folder where the Gorilla database resides.
  3. Locate the lock-file for the database.
    • This file will be in the folder with the database and have the same name as the database, but will have an extension of “.ldb” instead of “.mdb”. For example, if the name of your database is “B40.mdb”, then the lock-file will be named “B40.ldb”.
  4. Delete this file by right-clicking on it and choosing “Delete” from the menu.

At this point, Gorilla should function as normal and the error should be gone.