Posted by Tom van Stiphout on 02/01/08 05:20

On Thu, 31 Jan 2008 12:56:15 -0800 (PST), cbrewer2@kc.rr.com wrote:

(trying to guess what you mean) Yes, if you have an AutoNumber column
in an Access (better: Jet) table and you add a new row, the autonumber
will be different than the ones you already have. You should NOT
expect it to be the next number, just different from all others. That
topic has been debated so often it should not take you much searching
groups.google.com to understand why,
If you want sequential, there are ways to do it (DMAX+1 comes to
mind), but the question remains WHY, and what to do about deleted
rows.

-Tom.


>I am working with a database that was created in Lotus and importing
>it into Access. There are hundreds of clients in this data base that
>have to be kept and maintained. My question is: Will auto numbering
>work with this imported file and will it continue with the last number
>that is in there and if not can I make it work and how?

[Back to original message]