I was going to try to open the file with a hexeditor, change the header to read that there is 1 fewer records, then put the EOF at the end of the last record -1. I figure better they loose 1 record instead of 2 gig worth of data..heh


>Hi Victor,
>
>You give up too easily. :) There're a few ways to get that info:
>- You can open old version of the table. It doesn't have to have any records, just correct structure
>- You can use hexadecimal editor to read this info from the header of the corrupted table
>- You may have old LIST STRUCTURE printout for that table laying around
>- You can calculate it based on table structure
>
>>hmmmm...interesting idea ... but since VFP won't open the table I'm not going to be able to use the Header() and RecSize() functions.
>>
>>>Here's an untested idea. Using formula

nLogicalSize = HEADER() + (nRecCount * RECSIZE()) + 1

find the size closest to 2GB but less than that. Use FCHSIZE( ) function to change your table size to that. After that you may try to fix table. As usual, make backup before trying anything. :)