I need to get past a system resource error.
I'm using Access 2k on a machine with 3GB and an XP SP3 workstation.
Initially I was exceeding the 2GB space limit of the backend database, so I upsized to MS SQLSERVER and not receive a System Resource Exceeded message.
At the time that the code fails it is looping through 60K records, and saving data into a MS SQLSERVER backend table.
Am I running out of memory, hard drive space, variable space, or something else?
From performance tab. Screen shot take immediately after I broke out from error...
Physical Memory 2095084
System Cache 917644