Auto Number Field

[Guest]

I have created auto no field. I was doing testing of database and hence have
fed in lot of data for testing purpose. Now i want to delete data and give it
for live data entry. Problem arises, that auto no field has already assigned
few values and whenever fresh values are insterted auto value field has next
value. Eg if i have entered 70 transactions for testing, auto field has
generated 1-70 values. Now if i clear database and give it to users, the next
value in auto field is 71 but i wanted to start with 1. Please help.

 

[Steve Schapel]

Sandy,

After deleting all the records from the table, compact the database.

 

[Guest]

After the records are deleted from the table, you need to run Compact and
repair on the DataBase, that will initiate the AutoNumber back to 1.

For future reference, the autonumber wont fill up holls in the record, so if
you delete a record in the middle it wont be automatically filled

 

[Joseph Meehan]

I have created auto no field. I was doing testing of database and
hence have fed in lot of data for testing purpose. Now i want to
delete data and give it for live data entry. Problem arises, that
auto no field has already assigned few values and whenever fresh
values are insterted auto value field has next value. Eg if i have
entered 70 transactions for testing, auto field has generated 1-70
values. Now if i clear database and give it to users, the next value
in auto field is 71 but i wanted to start with 1. Please help.

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
particual application.

 

[Guest]

Thanks

Sandy,

After deleting all the records from the table, compact the database.