Register and Join the most happening forum of Sikh community & intellectuals from around the world.
Discussion in 'Information Technology' started by Steve, Nov 2, 2005.
Is there a way to reset the numbering without making a whole new table?
Yes, compact and repair the MDB, that will reset the counter.
If the table empty the counter will start again from 0, if the table has
data the counter will reset to the last number entered
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.
> Is there a way to reset the numbering without making a whole new table?
> Is there a way to reset the numbering without making a whole new
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
There are other ways of providing the numbers you want depending on the