Microsoft Access: Not enough temporary storage space error

KNOWLEDGE BASE

Microsoft Access: Not enough temporary storage space error

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

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.

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