I have a user that just got a new laptop, but he has downgraded from 4GB to 2GB with this new laptop on Windows XP, and is still running Access 2007. The database is local to his machine with calls to Data Warehouse tables through ODBC.
When I got the help ticket it he said the query will run for 1 hour or so then flash the error, "Not enough space on temporary disk".
After some googling I found one entry to increase the file lock size in the registry from 9500 default to 200000. This allowed the query to run for about 1.5 hours and then flashed the same error. I also asked the user who the database designer was and he left the company 2 years ago, as I was hoping to possible maybe redo the query and see if it can be condensed.
User stated this query generally took 2 hours or so to run on his old laptop, as he is a home office VPN user.
I checked the user's temp folders (c:\temp, and that in his profile) and only one of them has 86MB in it so not that much.
The user's pagesys is set to the max 2GB, and he has plenty of hard drive space.
Was trying to find him a fix, but from what I am seeing the Ram is required for this database.
Any ideas if there are other settings I can try?