Table autonumbers - possible reset?

[Bob]

Can anyone suggest a possible solution. I am developing
an MS Access Application and in the course of development
I'm entering dummy data to verify functionality. At the
end of the development cycle I would like to wipe the
contents of the db and have all the autonumber fields
reset themselves so that when new entries are made the
real data that is being entered has autonumber entries
that begin again at 1.

Can anyone suggest a good way of being able to achieve
this?

Thanks
Bob

 

[tina]

after deleting the "dummy" records in the table(s), compact your database.

 

[Joseph Meehan]

Can anyone suggest a possible solution. I am developing
an MS Access Application and in the course of development
I'm entering dummy data to verify functionality. At the
end of the development cycle I would like to wipe the
contents of the db and have all the autonumber fields
reset themselves so that when new entries are made the
real data that is being entered has autonumber entries
that begin again at 1.

Can anyone suggest a good way of being able to achieve
this?

Thanks
Bob

Tina suggested a way to reset the numbers.

I suggest you may not want to use Autonumber for that use. Autonumbers
are designed to provide unique numbers. It in not designed to provide
numbers in order and for a number of reasons may not do so. As a result
using them in any application where the user sees the numbers is likely to
end up with confusion.

There are other ways of providing the numbers you want depending on the
particular application.