Need to compress/remove records from 2GB key file

Don Coleman dcoleman at dgcreact.com
Tue Jan 9 06:45:00 PST 2007


Windows native Fp5.0.13, Windows 2000 Advanced Server, WIN2000 & WINXP Pro
clients.  

I have a key file which last night exceeded the 2GB limit and I can no
longer access the data.  IUA reports zero records, the fP Directory reports
-1736042 records.  I believe approximately 50% of these records are empty
and need a way to slightly reduce the size so fP can again access the file.
At that point I can archive the used records, delete the unused records and
start with a new key file again.

Does anyone have a method outside of fP to do this?  I seem to remember Bob
Stockler or JPR having an OS utility to "deflate" a file.  Is this a UNIX
only solution or is it available for Windows as well?

Or is there a way to accomplish this from within fP.  I'm assuming not since
presently I cannot access the data.  I'm hoping to not have to remove
several records with a hex editor or other such utility because it is
important to recover this data and I have not previously had to do this.

Don Coleman
Donald G. Coleman, Consultant
402 Andrew Circle
Indiana, PA 15701
dcoleman at dgcreact.com
(724) 349-6302




More information about the Filepro-list mailing list