Could a deleted Random Autonumber value be reused?

G

Greg-the-Grey

I plan to use a table with an autonumber whose records are continually being
created and deleted. In theory if I use an incremental autonumber I could
reach the maximum value. Should I use a random autonumber instead? Does
Access reuse previously deleted random numbers? Reusing previously generated
and deleted random autonumbers in my database would be acceptable.

Regards

Greg
 
A

Allen Browne

Are you likely to create and delete a million records a day for the next 5
years?

That's what it would take before the AutoNumber starts overflowing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field 5
Autonumber Changed to Random 4
Autonumber random becomes scientific 4
Replace deleted records in table that uses Autonumber 6
Auto-number 'increment' changed to 'random' converting to access 2 2
using a puesdo record/autonumber in a make table query 6
Random records 3
Autonumber field - increment 2

Top