If you get the following error in Microsoft Access:
Not enough space on temporary disk.
This is because the query you are running is dealing with too much data. It’s reaching it’s maximum virtual table size (which is a couple of Gb, I think).
To fix the space issue, alter the query to deal with smaller chunks of data (turning it into multiple queries), or get a real database :p