System Resource Exceeded

[Mike]

When I run the query below I get an error "System Resource
Exceeded". I restarted my compter to no avail. It worked
with 20 records but not with 50. Please help. It's a
maketable query but I can even preview it.

SELECT [pay generator 3].[SS#], [pay entry].[Check
Advance], [pay entry].[Card Advance], [pay generator 3].
[Net Pay3], IIf([Net Pay3]>[Check Advance]+[Card Advance],
[Net Pay3]-[Check Advance]-[Card Advance],0) AS [Net Pay4]
INTO [pay gen 4]
FROM [pay generator 3] INNER JOIN [pay entry] ON [pay
generator 3].[SS#] = [pay entry].[SS#];

 

[Mike]

I found a way out. I chose to not have the Net Pay3 in
the new made table. Thanks

 

[Gary Walter]

Hi Mike,

I don't have a specific cure, just
some suggestions.

1) start a new db,
turn off AutoCorrect,
then import everything from
original db.

Do you still get the same error?

2) "wild hunch":
Are you running Norton Antivirus
in consort with Veritas backup software?

4) What happens if you turn off all other
software running in the background?
**I would suspect this most of all***

5) If you open Northwind sample db
and try to run a similarly-formed query,
does it run properly?

6) What version of:
Access?SP?
MDAC?
Jet?

7) Is this a split db? If so, where is the backend?
Is the backend an Access db or other?

8) How long since you performed maintenance
on your hard drive (scandisk/chkdisk, defrag)?

9) How many files do you have in your TEMP dir?
Fred Langa provides some files for cleanup here:
http://langa.com/cleanup_bat.htm

Sorry...more questions than answers...

Good luck,

Gary Walter