Run-time error '3183' Not enough space on temporary disk

[GVR_Mike]

Can anyone shed some light on what this error means and how to fix it?
This database runs automatically each week and has worked fine up
until today. Now each time it reaches a specific query it gives me
this error. Does this have something to do with the jet*.tmp files? I
can provide more info if needed. Thanks in advance.

 

[Guest]

How big is the datebase file(s)? The newer versions of Access have a maximum
of 2 GB size.

You could try to do a Compact and Repair to bring down the file size.

Also check how much free space there is on the drive holding the database
file. You could just be running out of disk space.

 

[GVR_Mike]

How big is the datebase file(s)? The newer versions of Access have a maximum
of 2 GB size.

You could try to do a Compact and Repair to bring down the file size.

Also check how much free space there is on the drive holding the database
file. You could just be running out of disk space.

It's Access 2000. The database starts at 21MB and I have it compact/
repair on close, but the database has over 300 queries (all make-
table). This is probably not the best design and it may grow to larger
than 2GB by the time it gets to this error. I'm running it again now
and will check the size when it gives me the error.