|Case Summary: 64 Bit ODBC Drivers Now available for Access
|Date Created: ||12/16/2013|
|Last Modified: ||12/16/2013|
|Problem Type: ||Comment|
|Item: ||Web+Center 7.5|
32 versus 64 bit compatibility is very important when running Web applications running under IIS. We wrote a special newsletter article about these 32/bit compatibility issues back in 2009 with newsletters #57.
The basic summary of this issue is that one must have all of the components (databases and drivers, any complied 3rd party add on products and scripting/web services all running in either 32 bit mode OR 64 bit. No mix and match! As vendors started creating updated versions, they started provided updates in 64 compatible formats while the critical64 bit Access database driver component from Microsoft was not released until July 2013 from what I can tell.
We support both SQL*Server or Access as the backend database, and MS Access works well for many smaller tech support organizations. To support Access for the past few years under 64 bit Operating system, special install instructions were required to run IIS in 32 bit and find a hidden 32 bit version of the ODBC driver for Access.
This new Driver is now available from the Microsoft Download Site:
To install this download:
Download the file by clicking the Download button and saving the file to your hard disk.
Double-click the AccessDatabaseEngine.exe program file on your hard disk to start the setup program.
Follow the instructions on the screen to complete the installation.
Now that this option is available from Microsoft, we will be updating our Web+Center installations and upgrades instructions to use this 64 bit drivers as it eliminates steps to run your Web+Center and web server in 32 bit mode when you have a 64 bit machine. Feel free to forward this article to others in the industry who may be interested to know about this upgrade option.