System Resource Exceeded

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top