RESOURCE PROBLEMS

[Guest]

I need to run a macro with about 25 action queries to create a report. The
application runs out of resources after running the macro, and it locks up.
It needs to be compacted before any more work can be done. Is there anything
I can do with code to clear out the RAM and recover the resources so I don't
have to do a compact and repair?

 

[Guest]

25 action queries to create report(s)?!? Either you are importing and
cleaning up a lot of dirty data, or have a very convoluted database design,
or both.

What resources are we talking about? The Windows resources like memory;
maximum databases size issues; or something else? What error messages are you
seeing?

One thing that might, just might help is to remove all sorting in the
queries used to create the report(s). Reports basically don't care about the
order of the records it receives and does all sorting and grouping within the
report.

 

[Guest]

It is a database with a lot of sub tables and sub sub tables. I have a
report that tallies all the inventory, thus involving all the tables. The
resource at issue is memory. If I close and reopen the application, it works
fine until I try to create the report again.