Cannot Save
Fixing the 'Record cannot be saved' error
Although no user has yet reported this issue, I wanted to share what I found in
case someone out there needs it.
The Problem
By default, Calibration Control uses an MS Access database file (apecal.mdb) and within that file is a table of all
your equipment (tblEquipmentMaster). In this table, there is an AutoNumber field (MasterID) that automatically increments one
UNIQUE number for every equipment record you add. Therefore, if you already have 10 records in your database
numbered 1 through 10 and you add one more, the MasterID field assigns itself the number 11. Anyway, that's the way it's
supposed to work.
I came across a situation where the AutoNumber looses count. When you
try to add a new record the AutoNumber field tries to assign a number (like 10) to itself when there is already a record using that number. When this happens, you see the following message.
Allen's Solution
Fortunately, Allen Browne has published a solution for fixing
AutoNumbers when Access assigns duplicates. Allen's instructions are so easy to follow that you don't need to be an
Access guru to follow along.
My Solution
Just in case you wanted it, I took Allen's code (above), placed it in a small MS Access database, and
placed it on this website for you to download (sign-in required). If you are more comfortable with importing objects into Access (like tables of data), you can import the AutoNumberFix
module directly to your apecal.mdb database, make one small modification, run it, and you're done.
Step-by-Step
- After you download an unzip the AutoNumberFix.mdb, open your apecal.mdb with MS Access.
- Using MS Access 2007/2010 as an example, click on the 'External Data' tab and select the Access icon.
- Select the AutoNumberFix.mdb file.
- When you get to the Import Objects dialog, select the Modules tab, and import the AutoNumberFix module.
- Double-click on the AutoNumberFix module, which should now be imported into your apecal.mdb database, and you should see the
Microsoft Visual Basic for Applications window.
- From the Tools dropdown menu, select References, find 'Microsoft ADO Ext. x.x for DDL and Security', click its checkbox,
and then the [OK] button.
- Now, place your cursor insider the code and click the Play button in the toolbar or just hit the [F5] button on your keyboard.
- If it shows you a dialog like the one below, click the [Yes] button and you're done!
Last updated: 8/5/2011
Compatibility: Calibration Control versions 5.x