reset auto number

[Guest]

I have been working with accesss for a couple of years. I learned how to
reset autonumber to zero by appending a zero then deleteing files.
We have changed over to office 2003. This procedure does not reset the
autonumber in access 2003. Is there a different process that will allow me to
do this.

 

[Steve Schapel]

Bgarey,

Delete all records from the table, and then "Compact and Repair Database".

 

[Guest]

Thanks,
That was easy and worked

Bgarey,

Delete all records from the table, and then "Compact and Repair Database".

 

[Joseph Meehan]

Thanks,
That was easy and worked

Yes it is easy, but I wonder. Do you really want to use autonumbers?

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]

For the particular application that I was using autonumber is fine. There are
other places that autonumber is not ok. Where can I find out how to make
sequential numbers in access?

 

[Joseph Meehan]

For the particular application that I was using autonumber is fine. There
are other places that autonumber is not ok. Where can I find out how to
make
sequential numbers in access?

I have not needed them so I don't have the code, but if you start
looking back at autonumber threads or other numbering threads you will
likely find some examples. If not just start a new thread asking about it.
Someone will replay with an example.