Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo file too large
Message
 
 
To
07/04/2011 09:43:24
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01506357
Message ID:
01506364
Views:
87
>I have a table that periodically needs a PACK MEMO on it to keep the FPT file from growing too large. Once packed, the size of the FPT shrinks from near the 2 GB limit to some few hundred MB in size.
>
>I let it go too long so today I have Error 41's trying to get it open to perform a pack. Any ideas on how to do that?

You should look into why memo is growing so fast. Most likely it's result of to many updates on memo fields. Every time a memo field is updated, it's copied entirely to the end of FTP file (unless table is open exclusively).
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform