Table of contents
TOC
Collapse the table of content
Expand the table of content

Not enough space on temporary disk. (Error 3183)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

Applies to: Access 2013 | Access 2016

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.

ACCESS SUPPORT RESOURCES
Access for developers forum on MSDN
Access help on support.office.com
Access help on answers.microsoft.com
Search for specific Access error codes on Bing
Access forums on UtterAccess
Access wiki on UtterAcess
Access developer and VBA programming help center (FMS)
Access posts on StackOverflow

© 2018 Microsoft