Skip to main content

Error - 'This record is locked by another user and therefore cannot be used' when receipting goods

Updated over a week ago

This error means that someone has crashed out of the system whilst looking at this transaction which has left it locked. Usually this would have happened in Dimensions rather than FocalPoint.

To resolve the error, the "Multi User Flags" will need to be cleared. This is a process in Dimensions, instructions for which can be found below:

  1. Login to Dimensions as the ‘sa’ user or a user with an equivalent or master security profile.

  2. Ensure all other users are logged out of Dimensions Accounts.

  3. Check if people are logged out at System Control, Users, User Records.

Note: Make sure to have taken a recent back-up of the Access Accounts Database (If unsure how to do this please contact your IT service provider).

  1. Now go to System Control.

  2. Click on Data Utilities button.

  3. Click on Clear Multi-User Flags.

  4. In the ‘Multi-User Flags’ window, tick the ‘All Multi-User Flags’ tick box.

  5. Select the Green Tick.

This will run through and clear all the multi-user flags in the Accounts Database
Note: Please make sure to read any messages that may pop-up during the process.
Tip: If using the 'All Multi-User Flags' option does not work, try selecting the affected Module and System options and running them individually.

Did this answer your question?