Error - Invalid Operation when adding a new part record - OID field

 Product(s):promis.e, Bentley Substation
 Area:Component Management
 Subarea:Parts Database

Error or Warning Message

When trying to create a new part record in the [[Parts Database Manager]] with the "Apply part information from the current record to new part number" option enabled, you get an error message saying:

Invalid Operation


In some cases this error has been found to be caused by incorrect values in the OID field of the parts database. If that field is blank or is a duplicate of an already existing OID value, then you could get this error. The data type for the OID field is AutoNumber, so there should be a unique numeric value for each record. AutoNumber fields cannot be renumbered.

How To Resolve

To correct duplicate values in the OID field use the following process:

  1. Make a backup copy of the parts database.
  2. Open the database in MS Access.
  3. Open the table used for the parts database, probably the parts_database table.
  4. Switch to the Design View.
  5. Find the OID field and note the field properties.
  6. Delete the OID field.
  7. Create a new field named OID with the Data Type set to AutoNumber and with same properties as the original.
  8. Save and close the database.

 Original Author:Tani_S

Keywords: 66767, 500000085365