Corrupt File other than header with large file

[ScottMcD111]

I have a paradox table with over 400,000 records. The primary key is an integer field. I receive a "Corrupt File - other than header" message when I try to scroll the file using Database Desktop. (I get the error inside my app also) If I delete the primary index I can scroll the file. Once I restructure and create the primary key the error returns. The only temporary workaround I've found is to create a new file and copy the records. But the error returns within weeks. Any suggestions? Thanks in advance!

 

[ScottMcD111]

I solved my own problem. If anybody else receives this error you have to do the following: 1 - increase the block size for the paradox driver. (bde administrator) 2 - Create a NEW file (borrow the table def from the existing file) and copy the records to the new file. note: you must create a new file, simply emptying the existing file won't work.