"insufficient temporary disk space" error

[Guest]

I'm getting this messge when attempting to run a reasonably small make table
query. How do I increase my temp disk space and what is this? Any info
appreciated.

 

[gls858]

I'm getting this messge when attempting to run a reasonably small make table
query. How do I increase my temp disk space and what is this? Any info
appreciated.

When I get this error it's usually due do a mistake in one of the
limits in the query. Has the query ever worked?

gls858

 

[Guest]

Yes, have run this query before. I get to view the results ok in a view
query - it's only when I go to run a 'make table' query that I have the prob.
I'm guessing Access writes a backup, which goes to a tmp partition on the
harddrive. Just need to know how to up the volume in this part of the drive
if that's the case.

 

[gls858]

Yes, have run this query before. I get to view the results ok in a view
query - it's only when I go to run a 'make table' query that I have the prob.
I'm guessing Access writes a backup, which goes to a tmp partition on the
harddrive. Just need to know how to up the volume in this part of the drive
if that's the case.

:

Have you checked the free space on the drive(s)?

gls858