Could a deleted Random Autonumber value be reused?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 7
Add autonumber to a large table? 0
Auto-number 'increment' changed to 'random' converting to access 2 4
Resetting Autonumbers and creating new rows 1
restore a deleted record in table with autonumber field 2
Random Number in Table Field 1

Back
Top