Hello

I work whith Delphi 4.03 and Paradox 7.0 tables with BDE 5.01 in
monoposte on WIN95/98.

I have a big probleme with a big table ( 157 Mo of datas and 2 indexes
of 6
Mo ).
When I move heavily the vertical scroll bar of a DBGrid with this table
ranged I get
the message "file damage - other than header"
on one of the files of the table ( .db, .xg0 or .xg1 ).
If I quit my application and I come back everything is all right for the

table
until I move the scroll bar again.

I try all the reindex and restructures I found on the net without any
progress.

Please if you have any idea answer me !!!

You have a corrupt table.  You will first need to run a table repair on it.
There is one on the Delphi web site in the BDE utilities area.

    http://www.inprise.com/devsupport/bde/utilities.html

After the table is repaired, you need to make sure it's block size is 4K or
greater.  I think this can only be changed by another utility in the BDE
Utilities site.  The file name is pxrest.zip.  Also, using the BDE
Configuration Utility that came with Delphi, change your default block size
to at least 4K so that all tables will get the new block size from now on.
I think the Block sizes can be any of the following:

    Block Size            Max Table Size (Size of the .DB file)
          2048                    256 MB
          4096                    512 MB
          8192                        1 GB
        16384                        2 GB
        32768                        4 GB

I know you said your table size was 157 MB but we have found less chances
for table corruption with larger block sizes.  We have taken ours all the
way to 32K.  Some of our table are reaching the 2 GB size.  We are
converting some tables to SQL because of this.  Paradox doesn't handle the
large tables very well and a table corruption at this size takes a long time
to repair and sometimes runs out of disk space and can't be repaired.

Another really good table repair/info utility that is free (at least the
last time I checked on it) is the B&P Table utilities at

    www.bpsoftware.com

It can repair a whole directory of tables at a time.

Hope this helps.

--

Don Gollahon
(golla...@netexpress.net)