Sort order of Access table without index

From: Xie Bingpeng (xbp_at_teabird.com.cn)
Date: 06/25/04 

Date: Fri, 25 Jun 2004 09:56:26 +0800

hi all:
  I create a access 2000 file without any index or primary key(used for
report).
I empty this table and append some records into it, then fecth records with
a TADOQuery.
if I repeat this procedure again and again, the sort order of returned
recordset
may vary sometimes. that is, the record append is the same, but the sort
order(display in DBGrid)
is different some times. what's the porblem? how to resolve this issue?

 thanks.

Relevant Pages

  • RE: Form goes blank if no record in bound query
    ... To get around the no-records situation I have put some code into the form's ... Open event handler to check whether the table is empty and append a record ...
    (microsoft.public.access.formscoding)
  • Re: Sort order of Access table without index
    ... Del ... Just add autoinc int field to the table and make it primary key. ... >> I empty this table and append some records into it, ... >> if I repeat this procedure again and again, the sort order of returned ...
    (borland.public.delphi.database.ado)
  • Re: manipulating linked list
    ... initially empty. ... each ORIG item to L1 and each DUPLICATE item to L2. ... append L2 to L1 and return L1 as the result. ... *l2end = NULL; ...
    (comp.lang.c)
  • Re: Form and Subform record issues
    ... Just empty it with a DELETE query on opening ... the form and append its contents to the ...
    (microsoft.public.access.formscoding)
  • Re: List Performance
    ... So its actually faster to append to a long list than an empty one? ... They overallocate, and the amount of overallocation is dependent on the current size. ... But you can't do it directly from Python, ...
    (comp.lang.python)