I have lots of space; i get error "not enough space on temp dir."

[Guest]

I am trying to sort a 100million row datebase file. It opens fine. When i try
to sort it, i get the messege "not enough space on temporary disk" even
though i have 10 gigabytes free on both drives. How do i fix this?

 

[Guest]

A 100 million row database in Access?!? I'm impressed. The records must be
rather small.

Is this an Access database holding the records?
Are you using Access as the front end to something like SQL Server?
If so, are you using pass-through queries so that the processing is done on
the server and not your PC?

 

[Granny Spitz via AccessMonster.com]

When i try
to sort it, i get the messege "not enough space on temporary disk" even
though i have 10 gigabytes free on both drives.

It doesn't matter how much disk space you have available over 2 GB. Whenever
Jet needs to hold the results of calculations it creates a temporary Jet 4.0
database. If the operations you're requesting require more than this 2 GB of
temporary disk space you'll get that error message and the operation will
fail. You may be able to use Jet database engine settings to clear the cache
but it would only buy back a little of that disk space, if any, when you've
got 100 million records. Suggest you move the data to a client/server
database engine like SQL Express, which holds 4 GB. It's free.