Hi,


I am running a make table query. my access dB size is around 450 Mb. I am always getting the following error:"Not enough space on temporary disk"

My C drive and has like 30GB free. My temp folder reaches 1.95GB when I run this query (before that it is like 50mb). So I am thinking is it because of the Access 2GB limit (Access 2000) or is it because of some size restriction on the temp folder ?

Someone please help.
thanks in advance.