I normally do not use Access Databases, but for a pet project of mine I decided to quickly use Access 2010 Database to store some data. When I tried to add the database connection to my Windows Forms application, Visual Studio 2010 barked at me:
The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.
Even though it seems not logical, what fixes this problem is installing the Office 2007 System Driver: Data Connectivity Components.
Hope this helps someone…