October 17, 2018
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-dc16\Users\solson\Documents\CEO_Data.accdb","PWD=purduecpt")
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,
July 16, 2010
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.