Tuesday, February 25, 2014

The lock value must exist error when resetting ADX auto-number

If you try to manually reset the "Last Number Used" field in ADXStudio's Productivity Pack, you will receive an error that says, "The lock value must exist."  This is actually a good thing, because it means the locking code is working properly.  Here are the steps for resetting the Last Number Used field:


  1. Enter "1" in Lock Value field and Save
  2. Enter "1" in Lock Verification field.  Now you can change Last Number Issued to any value you'd like (e.g. "1000") and Save
  3. Clear the Lock Value field (blank) and enter "1" in Lock Verification field and Save
You are all done!