Thanks Anders. I don't have regular table corruption but it does happen
from
time to time; the last one was this week but that was the first one for
over
a year. When I went to access a particular record, Paradox closed down so
I
did a verify and it re****ted some errors, but said that everything was ok
after a rebuild - although the formatting, as I said, had gone. I will
back
up the .TV File as you suggest, if it happens again.
I don't use memo fields and I haven't been able to find out how to
identity
the block size. Would this make a difference?
Anders Jonsson wrote:
>> I'm using Paradox 10 as a flat file database with just over 100,000
>> records
>> with 52 fields. My forms work ok but I do a lot of work in the table
view
>> and
>> every now and then, over the years, I've had to rebuild a table after a
>> record has been corrupted.
>
>100 000 records shouldn't be a problem per se but 52 fields is a rather
wide
>table, but should also be OK. Regular table corruption is not normal in
>Paradox and usually caused by bad hardware, bad users or bad programming.
>Neither of this should an issue in your case as I understand it so there
>must be something else. What block size is the table. Do you have a lot
of
>memo fields?
>
>> When I do this all the formatting for the table
>> view disappears, leaving me with a plain white table. If I then recover
a
>> previous version of the table, the formatting is gone from that as well
>> (leading me to conclude that that the formatting is stored somewhere in
>> Paradox rather than in the .DB file itself??).
>
>The formatting is stored in a file with the same name as the table but
with
>.TV extensions. You could try to backup that file prior to your table
>rebuild and restore it afterwards. I haven't done this myself but it
might
>work.
>
>Anders
|
