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.


​

    • Related Articles

    • How to Delete a System User

      QUESTIONS THAT APPLY TO THIS TOPIC How do I delete a system user? One of our employees recently left the company, how do I get them out of the system? ANSWERDeleting a System User is not recommended. In fact, the system will not allow you to delete a ...

    • How to Edit a Speedbutton in Gorilla® 4.x

      QUESTIONS THAT APPLY TO THIS TOPIC How do I change the default Output Channel from "Printer" to "Email"? How do I include or change the "Message Subject" when it is to be sent by Email? What does "Pause for User Editing" do? How do I "copy" ...

    • How to Edit User-Definable fields in Gorilla

      QUESTIONS THAT APPLY TO THIS TOPIC How do I add or edit the List field? How do I add or edit a Keyword? How do I change what is in the lists with green backgrounds?  ANSWER Click on Tools>List Editor. Choose the name of the field you wish to edit. To ...

    • How to Resolve Issues with the Action To Do Report

      QUESTIONS THAT APPLY TO THIS TOPIC “Why is some information not appearing on my Action To-Do report?” “Why are there too many actions on my Action To-Do report?” ANSWER Virtually all issues with the “Action To-Do” report fall into two categories: ...

    • Error 2738 Could not Access VB Script Runtime for Custom Action

      PROBLEM When trying to install Gorilla on your computer, you get the message: Error 2738 could not access vbscript runtime for custom action.   CAUSE This error message indicates that the VBScript engine is not currently registered on the machine ...