Memory allocation error

  • Thread starter Thread starter nthdegree
  • Start date Start date
N

nthdegree

I keep receiving an error message regarding memory
allocation. I'm attempting to run a multi-query db with
several thousand records.
With task manager open and the db running, I can watch as
the "page file usage" slowly climbs to about 1.86 GB and
then the error message appears.
I've tried a couple of things to combat this:
(1) virtual memory is allocated 4 GB across 2 drives
(maximum available w/o causing other problems)
(2) temp files are stored on D: drive which has over 30
GB of free space.
any suggestions would be appreciated,
nthdegree
 
Hi,

The question is how big is your database and how big does it get while running the queries. As you know the filesize of Access dbs are limited to 2 GB, this includes Forms, Queries, etc. not only your data. Probably you're running out of space within your database/reaching the limit.

Probably you are able to split your datase into several backends or should think of amending the query / split into several smaller ones, doing the needed things step by step than all at a time.
 
Back
Top