By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,462 Members | 1,057 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,462 IT Pros & Developers. It's quick & easy.

autonumber

P: n/a
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?
Jan 31 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.
Feb 1 '08 #2

P: n/a
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?
Feb 1 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.