Excel Forum

Query to Access Database now password protected ODBC connection issue

Steve Olson

Member

Members

Power Query

Power Pivot

Power BI

Forum Posts: 26

Member Since:
October 17, 2018

Offline

December 19, 2019 - 3:59 am

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")

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