The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine exception

I got this exception when setting up an old website on a new 64-bit Windows Server. The system was using an old Access database for keeping statistics information, which did not seem to like the new environment.

Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine exception

As I did not have Microsoft Office installed on the server I had to download the 2007 Office System Driver: Data Connectivity Components from the Microsoft website. After installing this I was hoping that the exception would go away, but it turned out that the driver does not exist for 64-bit systems.

Advaced settings on an application pool in IIS7 showing it being enabled for 32-bit applications.

By going into the Advanced Settings on the Application Pool in the IIS 7 and setting Enable 32-bit applications to true, I was able to access the statistics data again.