One can easily run IIS in 32 bit mode rather than 64 bit by simply changing
the default application pool to "enable 32 bit" applications.
Thanks to an
article by Amy Blankenship on 64 bit Windows, IIS and Access, this simple solution
basically runs IIS in 32 bit and then allows integrated 32 bit applications and drivers
such as the Access ODBC 32 bit driver to run. This will make all of the applications
of the default website run in this 32 bit mode.
To change IIS to run in 32 bit mode,
- Open IIS manager and select the View Application Pools" on the right hand menu options
- Select the Default App Pool
- Click on Advanced Settings...
- Simply change the "Enable 32 Bit Applications" flag from False to True.
- Close IIS
Configure 32 Bit ODBC Drivers
By default on a 64 bit OS, the default ODBC Datasources setup is a 64 bit application
that only shows 64 bit drivers. Since Microsoft does not have a 64 bit Access driver so
you won't see any Access drivers available.
The 32 bit version of the ODBC database sources still exists on the 64 bit
machine, but you must run it separately using the START... RUN command with the file path: