autonumber

[cbrewer2]

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?

[Tom van Stiphout]

On Thu, 31 Jan 2008 15:22:22 -0800 (PST), --CELKO--
<jc*******@earthlink.netwrote:

I disagree that Access (better: Jet) is not a database. I guess it
depends on your definition, but by most definitions and by MSFT's
marketing materials, it *is* a database. How do you define a database?

-Tom.

>Neither ACCESS nor Spreadsheets are databases.

[Tom van Stiphout]

On Thu, 31 Jan 2008 12:56:15 -0800 (PST), cb******@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?