Microsoft Access: Not enough temporary storage space error

Published: 17 Mar 2021
Last Modified Date: 08 Jul 2022


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


  • Tableau Desktop 2020.4.0
  • Windows 10
  • Microsoft Access


  • 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?