Pages

Sunday, December 14, 2014

HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine


this resolution works with:
  • 64-bit Windows 7
  • 64-bit MS Office
  • Please reply to this thread if it worked for you so i can make this a full "compatibility list"

trying to connect to an Access database in visual studio but keep getting this error?

however if, like me, that doesnt work for you, try the following method:
NOTE: this DOES work for office 2010 even though it is for 2007 office, dont ask me why it just does :)
2. in VS click add data source, follow the wizard and enjoy! :)