OutputTo eats up ALL my MEMORY (1 Viewer)

[darren99]

when I use the outputto command to output a report to a file, about half of my system memory(512MB) is eaten up.

Though the outputto command does its job, all my memory is eaten up by it very quickly...and then I get an error forcing Access to close because it performed an illegal operation<--this is because of all the memory it took up...

Any help would be EXTREMELY APPRECIATED,

Thanks for reading.