>I have a .dbf file that is 76mb, however it's .fpt file is 1.86GIG.
>
>The problem I have is that when I issue a PACK...the .dbf get's packed...but I get an error when it gets to packing the .fpt file. "Not enough memory for file map". I have 4 gig of memory in the machine that's trying to perform the PACK. I'm extreamly concerned because this .fpt file is going to pass the 2gig limit in less than three days if I don't do something.
>Does anyone have any work-arounds?
>Thanks!
Two quick ideas:
select * from myBadTable into table myNewHopefullyOKTable
Or
PACK MEMO
And also scan the table and insert into new record by record having set BLOCKSIZE correctly and using Alltrim(Memo)
If it's not broken, fix it until it is.
My Blog