>Im trying to use OLE linking to provide a preview of .bmp images for a simple database application written in VFP6.
>
>I have an OLE bound control on a form whose control source points to a general field in my database table. I create the link using the the following command.
>
>APPEND GENERAL drwindex.olefield FROM (FileToLinkTo) LINK
>
>No problems with doing this everything works fine.
>
>My problem is that the FPT file associated with the database table gets very large. For example before I establish any links the FPT file is 5KB. If you link one 470KB bitmap the size of the FPT file jumps to nearly 2MB.
>
>It stays at this size even after you close the application, at first I wondered whether VFP was using it as some kind of temporary cache ?
>
>If you keep on linking you rapidly end up with a FPT file of several hundred MB's.
>
>I thought only the link was being stored ?
>What am I doing wrong ?
Look at the KB article on my web site that discusses Memo file bloat for some insights.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer