Our IT updated our server. In doing so they decided it was a good idea to password protect an access database that I am the only user.
I had created a file with 2 Power queries to simplify my month end process (working my way thru the Power Query Course). One built upon the other. First query pulled information from an Access Database query, and the other pulled from an excel file.
Now when I try to refresh the Power query to the Access database I get an ODBC connection error.
Of course I don't really know what is going on, so I google and added --- Source = Access.Database(File.Contents("\cpair-dc16UserssolsonDocumentsCEO_Data.accdb","PWD=purduecpt")
No luck.
Would anyone know if I'm on the right track, or do I beg and plead for IT to take off the password protection? The image below shows 1) what I must do inside Access to run a query, 2) my original Power Query, and 3) the ODBC connection message.
Thanks in advance,
Steve
Hi Steve,
Password protected Access databases are not supported. Your only option is to insist IT remove the password protection.
You can vote for this functionality to be included in future releases of Power Query here.
Mynda
Thank you for taking the time to respond so quickly. I will be taking your advice.
Steve
