Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sort Order (Win ME/Access 97)

    When I open a table in VBA, such as Set MyFin = MyDb.OpenRecordset("TFinancial", dbOpenDynaset), in what order will the table appear? It appears that the table opens in the sort order as specified in the primary key, in this case Customer. Will that always be true? Can I count on that sequence in my programming?

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Sort Order (Win ME/Access 97)

    Lacking other information Access will present the information from a table ordered by the Primary Key. I would not rely on this, however. If the order is important, use a query and specify the ORDER BY.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •