Skip Navigation Linkssite home | calibration control | help | cannot save

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.

Record cannot be saved

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

  1. After you download an unzip the AutoNumberFix.mdb, open your apecal.mdb with MS Access.
  2. Using MS Access 2007/2010 as an example, click on the 'External Data' tab and select the Access icon.
  3. Select the AutoNumberFix.mdb file.
  4. When you get to the Import Objects dialog, select the Modules tab, and import the AutoNumberFix module.
  5. 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.
  6. 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.
  7. Now, place your cursor insider the code and click the Play button in the toolbar or just hit the [F5] button on your keyboard.
  8. If it shows you a dialog like the one below, click the [Yes] button and you're done!
Alter AutoNumber Dialog

Last updated:  1 Jan 2013

Compatibility:  Calibration Control versions 5.x

Download Calibration Control

Email: *

Name: *

Company: *

Day Phone:


Graphic Charts
Calibration Event Structure
Status Code Visibility
Auto Notify Schedule
Calibration Measurement Templates