AddNew

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Gaffey - 30 Jul 2003 22:53 GMT

Sometimes when I use AddNew the added record is not at
the end of the Access table. It may appear at the
beginning or anywhere. How do I ensure the added recorded
is always appended to the end of the recordset/ Access
table?

Reply to this Message

Nelson Lee - 30 Jul 2003 23:36 GMT

Create an autonumber field in the table. If you do not already have a
primary key in the table, make this you primary key or else order/sort by
this field.

Nelson

> Sometimes when I use AddNew the added record is not at
> the end of the Access table. It may appear at the
> beginning or anywhere. How do I ensure the added recorded
> is always appended to the end of the recordset/ Access
> table?

Reply to this Message

Ben - 31 Jul 2003 00:39 GMT

An important question here is 'Who cares?'. In a RDBMS
the position of a record in a database table is
_absolutely_ irrelevant. If you are relying on the
position in the table for _anything_ you are going to
have some serious headaches.
If you don't have a primary key, then go with the
autonumber/identity field, but please DON'T count on the
position in the table. If you do have a primary key set
then that is why you're new records are not at the end of
the table, the primary key value doesn't fall at the end,
so Access puts it where it belongs. If you need a
speciific record filter or query for it.
HTH
Ben

>-----Original Message-----
>Create an autonumber field in the table. If you do not already have a
[quoted text clipped - 10 lines]
>
>.

Reply to this Message

VB Forum / Database Access / July 2003

AddNew