問題
嘗試連線到 Microsoft Access 365 時發生以下錯誤:"An error occurred while communicating with Microsoft Access. Download and install the drivers and then connect(與 Microsoft SQL Server 通訊時發生錯誤。下載並安裝驅動程式,然後連線。)
Unable to connect to the Microsoft Access database
"C:\Users\<username\Filepath\>accdb". Check that the path is correct and that you have access privileges for the requested file."
(無法連接到 Microsoft Access 資料庫
"C:\Users\<username\Filepath\>accdb" 檢查路徑是否正確,且您具有所請求檔案的訪問許可權)
或
"The drivers required to connect to the data source are not installed. The error may need to be resolved through local configuration changes on the Tableau side.資料庫錯誤 0x80040154:Class not registered Unable to connect to the Microsoft Access database "<filepath>.accdb". Check that the path is correct and that you have access privileges for the requested file."(未安裝連接到此資料來源所需的驅動程式。錯誤也許需要透過 Tableau 本機的組態設定來解決。資料庫錯誤 0x80040154: 無法連接到 Microsoft Access 資料庫「<filepath>.accdb」。檢查路徑是否正確,且您具有所請求檔案的訪問許可權。 )
錯誤在 Tableau Prep 為 Access 連線選擇檔案名稱後,或者在 Tableau Desktop 建立 Microsoft Access 連線時出現。