KNOWLEDGE BASE

"Database error: 0x80004005: Microsoft Office cannot open or write to the file" Error


Published: 30 May 2013
Last Modified Date: 08 Feb 2017

Issue

When performing a refresh of a view on Tableau Server, you may see the following error message.

com.tableausoftware.nativeapi.dll.DataSourceException: Database error 0x80004005: The Microsoft Office Access database engine cannot open or write to the file *. It is already opened exclusively by another user, or you need permission to view and write its data.
 
Unable to connect to the Microsoft Excel file "\\<file-path>.xlsx". Check that you have access privileges for the requested file and that it is not open in another application. 

Environment

  • Tableau Server
  • Microsoft Access
  • Microsoft Excel

Resolution

  1. The Tableau Server Run As User account must have permissions to access the network location where the  Microsoft Access or Microsoft Excel file is saved. For more information, refer to the Run As Account Settings to Confirm topic in the Server Help. 
  2. Ensure the path to the linked datasource is correct.

Cause

This issue is typically caused by insufficient permissions given to the Tableau Server Run As User account. 
Did this article resolve the issue?