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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I Manually Change Access Primary Key ID Fields ? 2
Data Entry Form and Auto Number ID 2
Count Number of days between records/events 2
Edited data record to be inserted as a new data record under the same PO number in Microsoft Access 0
need for a field with record no. 7
Update ID numbers that are not autonumber 4
Combine data in two records from same field 16
Launching Report from Form Only Shows Report for First Record 5

Back
Top