how do i expand the file temp dos to run a large query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

when i tried to run a rather large query my computer displayed an error
message after 20 mins that there was "Not enough space on the removeable
disk". i have tryed to expand the page file to its maximum but it didnt help.
i have got a 300gb hard disk and cannot understand why it's not working i am
using MS Access 2003 but i think the problem is with the temp file in windows
the database cannot be made smaller and multiple querys cannot be used

thanks
 
Can I presume the MDB is on your local c drive?

Can you also post the exact error text as I can't find this on MSDN or KB.
 
Back
Top