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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Greg-the-Grey" <(E-Mail Removed)> wrote in message
news:4E74F5E0-E6E7-4F4D-91D7-(E-Mail Removed)...
>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