auto number

dawson321

Registered User.
Local time
Today, 14:42
Joined
Jun 6, 2010
Messages
29
hi

I have made a database and done test on it to make sure everything works correctly.

is there a way to get the auto number to return to zero, for when real data is added?

thanks.
 
I believe that if you remove all the data from your table, and do a compact and repair, that this will reset the auto number.

However having said that, the only thing you can rely on the auto number to do, is to to produce a unique key for each record. It may not always provide a consecutive number and it may even provide a negative number under certain situations.

If what you are wanting a consecutive incrementing numbers search this forum on the subject of using Dmax()+1 to provide this result.
 

Users who are viewing this thread

Back
Top Bottom