KNOWLEDGE BASE

Microsoft Access: Not enough temporary storage space error


Published: 17 Mar 2021
Last Modified Date: 18 Mar 2021

Issue

Upon connecting to Microsoft Access from Tableau Desktop 2020.4, the following error is encountered:
Error code: 9F80FB23
Database error 0x80040E9A The query cannot be completed.
Either the size of the query result is larger than the maximum size of a database(2GB)
or there is not enough temporary storage space on the disk to store the query result.

User-added image

Environment

  • Tableau Desktop 2020.4.0
  • Windows 10
  • Microsoft Access

Resolution

  • Reduce the amount of data in Access
  • Disable the creation of temporary tables in Access by Tableau using a Tableau Capability Customizations (Tableau Datasource Customization) file.
Place attached the msaccess.tdc file in C:\Users\<username>\Documents\My Tableau Repository\Datasources
Did this article resolve the issue?