Geronimo24
Programmer
Hi everyone,
I put together a very simple Access Query that compares a Table A with 50,000 records and Table B with 30,000 records and updates a "duplicate" column in Table A if a duplicate record exists in Table B.
When I run the query, it never seems to finish, The blue status bar in the lower left corner hardly moves. When I open up the task mananger and go to "processes," I see that MSACCESS.EXE is taking up 99% of the CPU and 32,960K of the memory usage. The computer has tons more memory available. My guess is that the query is so large, and the memory usage allocated to the query is so small, that the query can't finish in any reasonable amount of time. Is there any setting that causes the memory usage cap to be at 32,960K? Can I possibly make it so that my query can use a lot more of the RAM?
By the way, I am using Windows XP. Thank you for any help.
Mike
I put together a very simple Access Query that compares a Table A with 50,000 records and Table B with 30,000 records and updates a "duplicate" column in Table A if a duplicate record exists in Table B.
When I run the query, it never seems to finish, The blue status bar in the lower left corner hardly moves. When I open up the task mananger and go to "processes," I see that MSACCESS.EXE is taking up 99% of the CPU and 32,960K of the memory usage. The computer has tons more memory available. My guess is that the query is so large, and the memory usage allocated to the query is so small, that the query can't finish in any reasonable amount of time. Is there any setting that causes the memory usage cap to be at 32,960K? Can I possibly make it so that my query can use a lot more of the RAM?
By the way, I am using Windows XP. Thank you for any help.
Mike
