Record vs. addressid

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob - 26 Apr 2006 21:02 GMT

Hello, I deleted a lot of records in the db. Now I have 85 records, with
addressid's in the 500's. Is there a way to reorder the addressid's so they
reflect the current records in the db.
Records increment by 1 as well as the addressid, but record # 55 may reflect
addressid # 485.
I am using the current record ID, and have created a field where I enter the
current matched record. No way to automatically capture the record # is
there? I don't see record as a field in the db table.
Bob

Reply to this Message

Douglas J. Steele - 26 Apr 2006 21:46 GMT

Unlike some other DBMS, Access doesn't expose a record number. That's
because in relational databases, there's no real concept of "record 1",
"record 2" and so on: records only have a ordinal number once you define
their sort sequence.

It sounds as though your addressid is an Autonumber field, in which case you
should be aware that Autonumbers exist for one purpose only: to provide a
(practically guaranteed) unique value that can be used as a Primary Key.
Rarely (if ever) should the value of the Autonumber field be presented to
the user, and no meaning should ever be assigned to it. In fact, if you ever
replicate your database, all Autonumber fields will be changed from
sequential to random.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Hello, I deleted a lot of records in the db. Now I have 85 records, with
> addressid's in the 500's. Is there a way to reorder the addressid's so
[quoted text clipped - 5 lines]
> is there? I don't see record as a field in the db table.
> Bob

Reply to this Message