How do I change the ID Record Key number from 366735 to 133?

H

HenHom

I had accidentially press a Control-V in insert an updated zip code in the
zip code field on one of the Access 2000 record. However, upon pressing the
Control-V, the cursor when to the ID record field and changed the ID value
from 133 to 366735. How can I change the ID record number from 366735 to 133?
I tried to do and Edit- Undo Typing, but it did not allow me the change the
ID record field.

Is there some command that I could use to change the ID record back into its
original value?

Thanks,
Henry Hom
 
D

Douglas J. Steele

If this is an AutoNumber field, you can't change it. Either live with it, or
delete the row, compact your database and reinsert the data.
 
Top