! Autonumbering Reset !

[Wembly]

Hi,

I'm using Access 2000 and was wondering if it was possible
to reset the autonumbering in a table?

Or is this wishful thinking?

Thanks

Wembly

 

[Chris]

Not directly, but try this ...
Right click the required table and select copy
Click in a blank area of the tables window ( so that no
table is selected.
Right click and select paste
enter a temp table name and select "Structure only"
then click OK

That will create a clone of your table.
You can populate the new table with an append query from
the old, or simply delete the old one and rename the new
one.

 

[John Vinson]

Hi,

I'm using Access 2000 and was wondering if it was possible
to reset the autonumbering in a table?

Empty the table. Compact the database. That's all it takes...

Note that the actual value of an autonumber should be *TOTALLY
IRRELEVANT* - autonumbers will always have gaps, and should not be
used in any way which assigns any importance to the actual values
stored. Most developers conceal autonumbers from user view at all
times.

 

[Michael San Filippo]

You can also just do an append query into the autonumber field of what you
want to set it to.

Say you want to reset the autonumber to 1000

all you have to do is make an append query to append into the autonumber
field the number 999 (assuming that is not already being used.

If you have other REQUIRED fields in that table, you will also have to
append some kind of data into those fields also.

Once you have this trick down - it will take you less than a minute to do
whenever you wanna do this again.