System Resource Exceeded

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lisa - 28 Sep 2007 22:35 GMT

I am trying to append data into a large table. Currently the data is at
52000 lines. When I tried to append the next Excel spreadsheet I get the
error " System Resource Exceeded"

Most of the searching I have done on Microsoft indicates that this is a
complex query issue, however I am not running a query, I am importing
(appending) data into a large table.

I am currently using Access 2000.

My own internal company help desk is useless. Anyone have this issue
before? What can I do to fix it?

Signature

Lisa

Reply to this Message

PhilT - 28 Sep 2007 23:23 GMT

I have a same situation with Access 2000, but try to upgrade more memory for
your computer should sold the problem. I have over 800,000 records, and 512MB.
I run crosstab but system stop, I then run the same database in laptop with
1GB, and no error.

>I am trying to append data into a large table. Currently the data is at
>52000 lines. When I tried to append the next Excel spreadsheet I get the
[quoted text clipped - 8 lines]
>My own internal company help desk is useless. Anyone have this issue
>before? What can I do to fix it?

Reply to this Message