Before posting I searched the Lounge but the respective threads did not help.
I have an .mdb database with several tables. One of them (henceforth "the table") has some 400,000+ records, and is a portion of a bigger table. The database is 1.2 GB big, so being conservative the table should be at the very most 600 MB.
Now, the problem. I want to insert a primary key field in the table. I first tried creating an autonumber, autoincrement long field using the GUI (ie, not via SQL commands). Before saving I also set it to be the primary key. When I save, Access takes a while and then throws the message:
"Not enough space on temporary disk"
The prompt has two options: "Ok" and "Help". When I choose the latter, the following message appears:<blockquote><hr>Not enough space on temporary disk. (Error 3183)
You tried to perform an operation that requires more space than is available on the temporary disk. Your temporary disk location is based on the TEMP DOS environment variable, which was set when your system started.
For example, you may be trying to create a query that creates temporary files larger than the temporary disk. Reduce the size of the temporary files by accessing smaller amounts of data at one time or increase the size of the temporary disk.
You can increase the amount of available temporary disk space in several ways:
Select fewer records. Dynaset-type, forward-only