Restoring a lost field with a Unique Identifier

[DBinazeski]

In Access 2007 we have set up a database with approx. 2100 items, each with a unique identifier "ID Number" starting with 1. A select few records have been deleted.



Example: For whatever reason, whether accidentily or purposely deleted ID Number 206 does not show up at all, it's record has been removed. The fields skip from 205 to 207.

I understand that the fact that the unique iodentifiers are, in this case, numerals, not numbers. They count nothing, just show which record I am accessing. BUT I want 206 back.

Is there anything can be done to restore 206?? (Regardless of whether or not it comes back with the information previously populating the fields within the record). What's important to me is restoring a record identified by the # 206.

[weekend00]

you can add a new record with id=206:
insert into table1 (id) values (206)

[DBinazeski]

My problem is:
In the table, the column label "ID Number" can not be editted. Even in the row which is left available at the bottom of the table for new records. The only way, that I know of, to populate the ID Number field is to enter a value into any other field.

[RuralGuy]

Weekend was suggesting using SQL to APPEND the record with the ID of 206. http://allenbrowne.com/ser-26.html

[DBinazeski]

Thank you. Got it figured out!

[weekend00]

you can even insert a duplicate autonumber ID if you don't set a unique index on it.