Re: Primary Key not sorted
From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 06/16/04
- Next message: John Vinson: "Re: Excel Into Access (With Correct Email Address - Muppet !!)"
- Previous message: Eric Butts [MSFT]: "RE: Input Mask Error"
- In reply to: Mike: "Re: Primary Key not sorted"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: Primary Key not sorted"
- Reply: anonymous_at_discussions.microsoft.com: "Re: Primary Key not sorted"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 16 Jun 2004 12:16:24 -0600
On Tue, 15 Jun 2004 15:08:14 -0700, "Mike"
<anonymous@discussions.microsoft.com> wrote:
>If I add a record using Access it is not sorted even
>though the Company field is the Primary Key but if I
>Compact and Repair the database and then open it back up
>it is sorted by Company name.
Correction:
The records are *DISPLAYED* in Primary Key order, as a convenience for
the user.
They are not *STORED* in Primary Key order - just displayed.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
- Next message: John Vinson: "Re: Excel Into Access (With Correct Email Address - Muppet !!)"
- Previous message: Eric Butts [MSFT]: "RE: Input Mask Error"
- In reply to: Mike: "Re: Primary Key not sorted"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: Primary Key not sorted"
- Reply: anonymous_at_discussions.microsoft.com: "Re: Primary Key not sorted"
- Messages sorted by: [ date ] [ thread ]
