At 04:15 AM 10/16/2007, you wrote:
Subject: Re: DB question, searching
From: r r <[EMAIL PROTECTED]>
Date: Mon, 15 Oct 2007 17:54:33 -0700 (PDT)
X-Message-Number: 5
Thanks for the idea... to see if I understand this
correctly, mainly the index counting in the PDB... is
the first record in the database index zero or one?
I have also read about unique Id and index. are these
the same thing or different?
Indexes start at zero and are dynamic, so if you insert a record in
the middle of the file (which you can do!) then the index numbers
beyond it are incremented by one. Indexes are also UInt16.
Record ID's, which are UIn32, uniquely identify each record and don't
change, except if a file is restored by HotSync.
But a warning... You should avoid high record counts! Although you
can have 64K records, you should avoid getting significantly over
10K. If you need more records then start treating each PDB record
as a block and put multiple actual records in each block.
Roger Stringer
Marietta Systems, Inc. (www.rf-tp.com)
--
For information on using the ACCESS Developer Forums, or to unsubscribe, please
see http://www.access-company.com/developers/forums/
