问题
尝试连接到 Microsoft Access 365 时,出现以下错误之一:“An error occurred while communicating with Microsoft Access. Download and install the drivers and then connect(与 Microsoft Access 通信时出错。下载并安装驱动程序,然后连接)
Unable to connect to the Microsoft Access database(无法连接到 Microsoft Access 数据库)
"C:\Users\<username\Filepath\>accdb". Check that the path is correct and that you have access privileges for the requested file.("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 的连接时出现错误。