Access 2010 - Memory allocation for Query
Posted on 2011-03-23
I have 2 Sony laptops and have been successfully been running an Access query successfully for several years. I've decided to bring a backup Sony laptop to the same level. Running the exact same Access files, the backup computer says query too large or temp storage not sufficient.
Computer 1 (works great) Sony SZ120, 32Bit, Vista Ultimate, 2GB, 300GB (141GB free), Access 2007
Computer 2 (problem) Sony Z520N, 64bit, Windows 7 Professional, 8GB, 300GB (125GB free), Access 2010
I have tried; compacting database, removing fields from query, deleting unused tables. The .accdb file for computer 1 is 1,785,288KB and 514,444KB for computer 2. Is there something with Windows 7 (64)/Access 2010 that is less efficient for memory management or is there something else I may be overlooking? The specific error (3138) is "The query cannot be completed. Either the size of the query result is larger than the maximum size of a database (2GB) or there is not enough temporary storage space on the disk to store the query result".