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 — type, and snapshot-type Recordset objects record keys and data to the temporary disk.
- Select a different drive for your temporary disk.
- If the temporary disk is a RAM disk, increase the amount of available RAM and the space allocated to the RAM disk, or move it to a fixed disk.
- Free some space by deleting data or by removing unneeded tables, queries, forms, macros, and modules from your database.
- Free some space by compressing deleted records out of your database.
- If you still need additional space, consider removing other unused files from your disk.