System Resource Exceeded error

[chengsi]

Hi guys,

I get the "System Resource Exceeded" error when I run a report, but the query which it is based on runs ok (take about 1.5 mins to run tho).

Anyone have any suggestions on how to avoid this error/use less resource?

Much appreciated.

[PEB]

Certenly this is a hard query that gets a lot of memory!

So if there is no way to optimize your query, make it Make Table query

From the created table show the results in your report

[chengsi]

Certenly this is a hard query that gets a lot of memory!

So if there is no way to optimize your query, make it Make Table query

From the created table show the results in your report

Thanks PEB. Just wondering however, the database is for a client so it needs to by dynamic. Can this be done thru a Make-table query?

[PEB]

What do you mean under dynamic?

Simply on open report event run your query using
Docmd.openquery
or
Docmd.runquery ""

And assign as recordsource of your report your table name! I think it should work as you want!

Thanks PEB. Just wondering however, the database is for a client so it needs to by dynamic. Can this be done thru a Make-table query?

[chengsi]

What do you mean under dynamic?

Simply on open report event run your query using
Docmd.openquery
or
Docmd.runquery ""

And assign as recordsource of your report your table name! I think it should work as you want!

Yes I see. It worked. Thanks for your help!

[chengsi]

What do you mean under dynamic?

Simply on open report event run your query using
Docmd.openquery
or
Docmd.runquery ""

And assign as recordsource of your report your table name! I think it should work as you want!

Sorry, one other thing. Is there a way to prevent the "Are you sure you want to delete a table", and "Are you sure you want to add 3 records" etc. prompts from coming up when you run the Make-table query?

Many thanks.

[NeoPa]

Use DoCmd.SetWarnings().

SetWarnings Method


The SetWarnings method carries out the SetWarnings action in Visual Basic. For more information on how the action and its argument work, see the action topic.

Syntax

DoCmd.SetWarnings warningson

The SetWarnings method has the following argument.

Argument Description
warningson Use True (–1) to turn on the display of system messages and False (0) to turn it off.