Is the file in use? This is an error returned from the access db. Can you attach to it with MS Excel?
I believe you are seeing this error message because the path to connect to the data source is using a mapped path. Tableau Server uses the “Run As User” account to authenticate a data source. Because the “Run As User” account cannot access resources that have been authenticated in the security context of another user, it cannot use the mapped path.
To resolve this issue, edit the data connection in the workbook to use the full universal naming convention (UNC) path, and then republish the workbook. A UNC path is the full path of a resource or file that is stored on the computer, which includes the full computer name, drive, path to the file, and file name. For example, a text file with a mapped path to D:\datasource.txt has a UNC path that looks like the following: \\workstation1\d$\datasource.txt, where “workstation1” is the full computer name.
Note: A correctly configured Tableau Server “Run As User” account has permissions to the UNC path location.
I can connect to other Excel files and other Access databases. I will check out John's solution tomorrow.
Tried what John said. Same error. I can connect to other databases on the same drive and other Excel files. Thats weird? I had someone else in the office connect to the database I cannot connect to and they had no problems.
I just don't know what else to do?
Interesting... I can connect to the database if I use the ODBC connection. But not the Access connection. Any clue what I am missing on my computer?
Been at that site to, and updated my drivers. I am finding that the computers in our company are not set up the same. And of course we don't what each other is missing. It may not be something we can solve and may be an issue I have to take up internally and either reload software or work on another computer. Just seems odd I can connect with ODBC option but not with Access.
I certainly appreciate everyones responses!! If anyone thinks of another option or something I should look to find please reply.
Solution! I feel stupid but as I went into the Access master copy and was on the file tab there was a security issue that I had to Enable. I just did not notice this before. Why there is was an issue with an "internal" application I have no idea. I did not have to enable use to connect to other internal Access databases. So just enabling the access database took care of all my problems.
1 of 1 people found this helpful
For everyone that Ed's security issue doesn't help:
I had the same problem after upgrading Office2010 to Office365, but it wasn't anything with enabling.