Re: Sort order of Access table without index

From: Del Murray (Del.Murray_at_N_S_CreditHawk.Net)
Date: 06/25/04 

Date: Fri, 25 Jun 2004 08:08:53 -0400

Yes, Viatcheslav is correct. Without the autoincrement field (used as a
primary key also), there is not real DB that guarantees it will maintain
physical chronological order. xBase did but that is not a real DB.

Relevant Pages

  • Row cannot be located for updating
    ... I have a master table and a detail table. ... (autoincrement field and primary key in MasterTable) ... with the proper ID value! ... I've just discovered that even the primary key of MasterTable ...
    (borland.public.delphi.database.ado)
  • Re: Need for Speed!!!
    ... Create unique index on name field - it may be primary key. ... >Viatcheslav V. Vassiliev ... >> We have an import data routine that reads customer data (ie, name, email, ... >> from various sources txt, csv, xls, mdb, etc, and imports it into the ...
    (borland.public.delphi.database.ado)
  • Re: Row cannot be located for updating
    ... Both primary keys in MasterTable and DetailTable are Autoincrement field ... But the problem seems to be on the Primary key fields, ... > The master linking field in the detail table needs to be of type Integer ...
    (borland.public.delphi.database.ado)
  • Re: Modifying Sql server data through Access
    ... add a column with an identity value (or autoincrement field in SQL ... Sylvain Lafontaine, ing. ... I cannot give primary key to some of the tables as some tables are temp ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Row cannot be located for updating
    ... Value 0 appears only after posting the record, ... I didn’t write any single line of code, apart the ones in the AfterPost event. ... Setting the AutoGenerateValue of the persistent field ID (the autoincrement field in the table) to arAutoInc is totally useless. ... If the primary key is set on other kind of fields everything works. ...
    (borland.public.delphi.database.ado)