Please! Need Help Tonight!! How do I reset an Autonumber!!

[Guest_imported]

Please read the post below about resetting an Autonumber. I really really really need some help tonight. Thank you

 

[petrosky]

hi

try here

http://www.applecore99.com/tbl/tbl017.asp

or try

http://www.google.com

and type this in the search field...

resetting autonumber field


Good luck Remember- It's nice to be important,
but it's important to be nice

 

[BigTeeJay]

Another (fairly) easy way... go into design view,
change the field to another datatype, save it,
and change it back (this assumes that you dont
have any data in the autonumber, and just want to
start over at 1 or whatever).

Another option, copy the table, and when you
paste it back in, choose structure only, this will
give you an empty copy of the same table, with the
autonumber reset.

Tj

 

[mikey69]

There is an SQL way, if you have JET4. See my reply in another post today.

 

[FiendClub]

I reset the autonumber field [Order ID] in my order table every year. If you need to hold the records you already have rename the table to access those records later. The only info I have found on reseting and autonumber field requere you to start with no data in the field.

For example I save my orders table under a different name every year. ORDERS99 ORDERS00 etc. Once I have renamed them the ORDERS table is ready to be cleaned of any orders. Once my ORDERS table is empty the first Order I enter for the new year will be #1.

 

[DavidOlly]

In Access 2002 (and possibly earlier) "Compact and Repair data base" will reset autonumber to start at 1 (Assuming the table is empty)