I didn't catch the first part of this thread, but one thing that can lead to memory usage is the use of cursors. Whenever you do a lot of select statements into cursors, the temp directory can get pretty full (the bigger the cursor, the fuller the temp directory). Two solutions might be 1]After you use the cursor and know that you won't need it any longer, you can issue a "USE IN ALIAS('Cursor')" and this I think will release the cursor from memory or 2]write a custom class that monitors what actual names are being assigned to your cursors down in the temp directory of the local machine and in the destroy event of your form, it deletes that file from the temp directory.
Hope this is applicable to the original thread.


>I have a VFP 5.0a app that in which I have almost 400 users using. I had one user whose memory was decreasing as the day went on until finally they continued to get memory errors in my program. If they rebooted then they started with full memory capability again.
>
>We went around and around on this. It was very frustrating especially since this was a unique situation with just this one user.
>
>What we found was that they had an old printer driver that was not releasing the memory! It was not my program that was not freeing the memory but rather every print job. They happened to have a Hewlett Packard printer and once they downloaded the newest and latest printer driver their memory problems went away.
>
>Hope this helps.
>
>Phyllis