Not Enough Space on Temporary Disk error message

[mcl]

This is with Access 2000. I have a huge database. It 1.3 gb. It's on a 80gb
partitioned drive (C & D). Drive "C" has 12gb free and the file is located
on "D" which has 36gb free. I get the message occasionally when running
queries and certainly when I try to "repair & compact" the db. My system is
a 3 GHZ P4 with 1gb of RAM. So why am I getting this message? What's filling
up? Is there anyway to "tweak" a setting (including in the registry) to fix
it?

 

[mcl]

I went to the MS Knowledge Base and got this:

"CAUSE
The page locks required for the transaction exceed the MaxLocksPerFile
value, which defaults to 9500 locks.
The MaxLocksPerFile setting is stored in the Windows Registry.
RESOLUTION
There are several ways to work around this behavior:
You can use Regedit.exe to edit the Windows Registry and change the
MaxLocksPerFile value permanently.
You can use the SetOption method of the DBEngine object to change the
MaxLocksPerFile value temporarily in code.
If the error occurs when you run an action query, you can modify the query
and set its UseTransaction property to No.
Method 1: Changing MaxLocksPerFile in the Windows Registry
WARNING: If you use Registry Editor incorrectly, you may cause serious
problems that may require you to reinstall your operating system.
Microsoft cannot guarantee that you can solve problems that result from
using Registry Editor incorrectly. Use Registry Editor at your own risk.
Use Registry Editor to increase the MaxLocksPerFile value under the
following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0
To do so, right-click the MaxLocksPerFile value, click Modify, click the
Decimal option, increase the Value Data from
9500 to some higher value, and then click OK.
Note that this method changes the Windows Registry setting for all
applications that use the Microsoft Jet database engine version 4.0. "

I will try the registry hack but to what higher level should I use? What
physical meaning does "9500" have. As large a DB as it is what should I use?