Issue
When publishing a workbook whose data source is a Microsoft Access, Microsoft Excel, or text (.csv) file that is located on a shared drive, an error message similar to the following may occur:Error communicating with the repository (999): Vizql::Error: Unable to load workbook SampleWorkbook
Code: 999
Errors occurred while trying to load the workbook "SampleWorkbook". The load was not able to complete successfully. Microsoft JET database error 0x80004005: 'S:\Reporting\CompanyData\Q1-2011.xlsx' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
The table "TableauData" does not exist.
Unable to connect to the Microsoft Access database "C:\Program Files\Tableau\Tableau Server\data\tabsvc\temp\DB12.tmp\Data\zzAutomated_Reporting\DO_NOT_OPEN.mdb". Check that the path is correct and that you have access privileges for the requested file.
Code: 999
Errors occurred while trying to load the workbook "SampleWorkbook". The load was not able to complete successfully. Microsoft JET database error 0x80004005: 'S:\Reporting\CompanyData\Q1-2011.xlsx' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
The table "TableauData" does not exist.
Unable to connect to the Microsoft Access database "C:\Program Files\Tableau\Tableau Server\data\tabsvc\temp\DB12.tmp\Data\zzAutomated_Reporting\DO_NOT_OPEN.mdb". Check that the path is correct and that you have access privileges for the requested file.