Hi!
Strange. Does memory leak goes away as soon as you close VFP?
In addition, did you tried to install the latest version of ADO?
Finally, if you require this for automation service, I would suggest to make a supporting (controlling) service, that restart the main service each night or more often. This way you will forget about any memory leak in the main service, just because application will be restart.
HTH.
>Sigh. Well, I was praying that it would work. I hadn't seen SYS(1104) before. But, alas, it didn't. Same results.
>I had already tried creating and releasing the recordset each time it loops, but moved it out to speed things up when I found that it didn't make a difference.
>I appreciate the suggestion though :)
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.