>We have a Win2K pc that runs a VFP5 process about 2 times an hour 20 hours a day. Occasionally we receive the "SQL - Out of Memory" error.
>
>Does anyone have any suggestions for minimizing how often this error occurs.

There was something similar to this quite a while back and I believe that periodically closing the tables involved solved the problem.

In that case it was a simple thing to do causing no problems. Hopefully it will be in your case too.

good luck


>
>Thanks,
>
>Perry