I was getting the same error as well. What fixed it was going to the Providers object and right clicking on Microsoft.ACE.OLEDB.12.0 and selecting properties then putting a check...