Autonumber re-use

[dbrooks]

Anyone happen to know if there is absolutely anyway to re-use an autonumber that use to be in place, but the record got deleted? I know all about how if you delete all the records it just keeps going and never re-uses the old number. But is there a way to force it to do this? Thanks. -db

 

[Roni Sutton]

If you have a table with 100 records and you delete all the records, you can compact the db TWICE and your autonumber field will start over at 1. If you leave records in the table, though I know of no way to force the autonumber field to pick one that isn't being used as opposed to picking the number after the last number. You CAN create another field that does that through code, though. If you'd like, I can help you with that, but it would be fairly lengthy. Is there a specific reason you need to do this?

 

[dbrooks]

Of course right after I posted my question, I figured it out. All I had to do is append to the table and over write the autonumber with the appropriate number I want to use. This worked first try, but Its good to know if I don't have any records in my table and compact twice I can re-start the autonumber. Good information. Thanks for your response. -db