B
Bev
Has anyone received this error when running an append query from AS400 to MDB.
We cannot determine where the TEMPORARY FILE is located and we keep getting
the MS Access Error:
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 – 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.
Unsure how to correct the error. And not even sure if the error is the real
problem.
Any help would be appreciated.
We cannot determine where the TEMPORARY FILE is located and we keep getting
the MS Access Error:
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 – 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.
Unsure how to correct the error. And not even sure if the error is the real
problem.
Any help would be appreciated.