error message "not enough space on temporary disk"

[P Straube]

Michael
Sorry to impose but I ran across the same problem and can't find anything in the MS KB
I'm running an update query in Access 2003 under Win XP Pro. The total database is about 1 gig and I have 4 - 6 Gigs free on each of my three partitions so I wouldn't think space would be a problem. The update query simply updates only one field that represents 36,652 records
I'm really frustrated and have no clue what to do
Any help will be appreciated
Thanks.

 

[david epsom dot com dot au]

1) Message typically means, not enough space on temporary disk.
Where is your temp folder?

2) How are you running query? will it run from db.Execute or
from macro with Transactions turned off?

(david)

Michael,
Sorry to impose but I ran across the same problem and can't find anything in the MS KB.
I'm running an update query in Access 2003 under Win XP Pro. The total

database is about 1 gig and I have 4 - 6 Gigs free on each of my three
partitions so I wouldn't think space would be a problem. The update query
simply updates only one field that represents 36,652 records.

 

[david epsom dot com dot au]

When you run query from within macro, there is an option for turning off
transactions.
Look immediately below the query name for the second entry field.
Transactions use
the temp folder for the transaction file. Sometimes badly formed queries
just use up
2GB of transaction space, which is the maximum before getting this error
message.

(david)

David,
Thanks for your response.
My Temp folder is C:\temp. That drive has 10.6 Gig free.
Unfortunately, I have no idea what "db.Execute" is. I have run the query

within a macro and simply on its own with the same result.