system resource exceeds

[cliff]

Hi, I am using access 2003 and access 200 database file format. when I
execute mutliple query's on query I get error message system resource
exceeds. can u tell me how to tackle this error.


thanks in advance

cliff

 

[Jerry Whittle]

It's a known problem with Access 2007:
http://support.microsoft.com/kb/918814

In all versions it's mostly just a generic error that's often close to a
query too complex problem. If you are running multiple queries that are based
on other queries, you just might be overtaxing Access. How to fix it?

1. Simplify the queries. Maybe you can use a subquery instead of basing
things on another query.

2. Fix the database structure. If your data isn't normalized properly, you
may have to run very complex queries to extract the data.

Maybe you could post the sql of a problem query and some sample table data.