"John W. Vinson" wrote in message
...
I think we are saying the same thing in different ways. Autonumbers cannot
be reused, whether the record is started or deleted. Once used, it's gone.
In that we're in agreement, and my take is that this fact makes
autonumbers
completely unsuitable if sequential gapless numbers are required.
The original request did not mention gapless as a requirement. In any case,
and system that allows deletions cannot, by definition, be guaranteed
gapless.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com