Hi Mark,
One more thing just sprang to mind. I had endless problems with indices
on Paradox tables and eventually tracked it down to having a large
number of records (100,000+) and the block size set to 2k (by default).
For those few large tables, I specifically changed the BDE Paradox
Driver settings to 32k block size, re-created the table (Borrowing the
structure and index definitions from the original table) and then added
all of the records from the original table to the new table. Since then
I haven't had any problems with corrupted indices.
I also noticed that this only happened over a slow network, and I never
seemed to get the problem if the files were on a local drive.
Regards,
Bevan
--
Bevan Edwards mailto:[EMAIL PROTECTED]
Achieve Software Limited http://www.achieve.co.nz
Phone: (64-9) 444-4210 ICQ: 732011
Fax: (64-9) 444-4201
Mobile: (64-21) 979-603
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
