not enough space on temporary disk

[Guest]

i get an error saying how there isn't enough temporary disk space when i try
to run a make-table query exported to another database. the funny thing is,
i've run the database before with older data and it worked just fine. all i
did was import updated data (with the same number of records, same format,
etc.) and the same macros. i don't see why it won't work here.

i have also defragged, compacted/repaired the database, rounded values in
the records, and tried an append query (into the table with the proper
definitions) instead of a make-table. nothing worked.

any ideas? thanks.

 

[[MVP] S.Clark]

My theory would be...

Access knows that it needs to run the query, so it looks to see the current
size then estimates how much space it will need to complete the operation.
It looks at the remaining filespace on the drive, and gives a pass / fail
response.

Either that, or the files = 80 buffer = 80 setting in the config.sys is
needed. (I think config.sys is where that goes.)