Query cannot be completed

[Tony]

I recently had a problem on my Microsoft Access database.

"The query cannot be completed. Either the size of the query result is
larger than the maximum size of the database (2GB) or there is not enough
temory storage space on the disk to store the query result"

I have an Dell Optiplex 755 running Windows XP Professional with 2GB of ram
and running Access 2007.

 

[Jerry Whittle]

1. Do a Compact and Repair of the database file. Using something like Windows
Explorer see what the file size is after compacting.

2. Run the query again. See what the size is afterwards or after it quits.
Is is near the 2 GB limit? Note: Press on the F5 key a couple of times when
in Explorer to get the latest info. Also look at the free space on the hard
drive and make sure there's a couple of GB free. Right click on the disk and
select Properties.

3. Post the query here by showing us the SQL. We might see something amiss.
Open the query in design view. Next go to View, SQL View and copy and past it
here.

 

[John W. Vinson]

I recently had a problem on my Microsoft Access database.

"The query cannot be completed. Either the size of the query result is
larger than the maximum size of the database (2GB) or there is not enough
temory storage space on the disk to store the query result"

My guess is that there's an error in the query, such as a missing join line.
For example, if you have a query with two 10,000 row tables joined by a
foreign key you'll have on the order of 10,000 or fewer records in the result;
if you omit the join you'll get 100,000,000 records!

Please post the SQL view of the query and indicate how the tables are related,
if at all.