AutoNumber

[Nicolette]

Is there a way to reset an autonumber field after testing the db without having to delete the relationships?

Also can you tell the autonumber field where to start say 100 instead of 1?

 

[PNGBill]

To reset, after you delete the record, do a compact and repair and you should be able to create a new record with the same number as the one you just deleted.

This only goes back to the last record ie, it won't allow you to reuse numbers missing from a sequence where a later number is being used.
1,2,3,4,5 delete 5 and reuse but delete 2, sorry, not possible unless you delete 2,3 4,& 5.

test on a sample table.

Check the properties on your autonumber, I think there is a setting to put the start number.
You can also use Formatted number I understand.

 

[Nicolette]

Thanks I read about resetting the autonumber somewhere but I couldn't find it again! thanks so much!

 

[gemma-the-husky]

having said that - you should not bother what the autonumber is - its just a unique identifier generated by access. if it matters to you, then using an AUTONUMBER is the wrong solution. In that case do not use an autonumber. Use a different technique to generate a numeric sequence.

 

[Nicolette]

true! don't really know why i was worried about it LOL!