I have some records e.g. 150 in my table "Cases". After deletion all records, I want to start numbers from 1 to onward in "ID" field. How it possible?
-
-
It's never a good idea to design your system so that what the numbers are matters.
That said - there are a couple of ways to achieve this :- Delete the records then Compact and Repair the database they're held in.
- Copy the table and Paste it back using a new name and selecting the option Design Only.
Delete the original table and rename the new one to replace it.
-
2nd that Neopa - with that said... sometimes after development I do like to start the tables out from scratch :)
My workaround for that is to create the table structures in the split backend... make a copy of that... and use the copy for my development work.
Aftab Ahmad : is this an "autonumber " field?
if so then you have this option (building on Neopa's)
ONCE AGAIN... this is NOT the recommended approach to database design - use at your own risk, I suggest making a backup first!
How to reset an AutoNumber field value in AccessComment
Comment