Address
304 North Cardinal St.
Dorchester Center, MA 02124
Work Hours
Monday to Friday: 7AM - 7PM
Weekend: 10AM - 5PM
64 Bit ODBC Access Driver for Web+Center
Welcome to Internet Software Sciences Newsletter – #111 – March 2014
Update: 12/5/2016 –
After some research, it appears that MS really does NOT want you to run 64 bit office/Access etc for several reasons.
The basic message.. if running ACCESS odbc, stick to 32 bit drivers!
Here are some reasons MS has listed on their page about 32/64 bit office installs:
Complete MS article at
https://technet.microsoft.com/en-us/library/ee681792.aspx
In addition to reviewing the Office 2013 system requirements, we recommend that you review these sections before you deploy 64-bit Office:
- 64-bit Office only works on 64-bit Windows
- Running 32-bit and 64-bit versions of Office on the same computer isn’t supported
- When you upgrade to Office 2013, the architecture versions must be the same for the old and new version
- If you want to switch between 32-bit and 64-bit versions, you must uninstall and then re-install Office 2013
- Some applications block 64-bit Office 2013 installations
You can install the 64-bit Office only on 64-bit versions of Windows 7, Windows 8, Windows 8.1, Windows Server 2008 R2, Windows Server 2012, and Windows Server 2012 R2.
Office 2013 doesn’t support running side-by-side installations of 64-bit and 32-bit versions of Office. For example, you can’t install Office 2010 32-bit side-by-side with Office 2013 64-bit. This applies to both Windows Installer (MSI) and Click-to-Run installations of Office 2013. If you try to do this, you’ll receive an error message and be prevented from continuing.
When you deploy the MSI-based version of Office 2013, you can only upgrade Office to the same architecture. For example, you can upgrade from Office 2010 32-bit to Office 2013 32-bit, and you can upgrade from Office 2010 64-bit to Office 2013 64-bit.
If you install 32-bit and then later decide you want to switch to 64-bit, you have to uninstall the 32-bit version, and then re-install the 64-bit version. The reverse is also true—going from 64-bit Office to 32-bit Office also requires an uninstall and then a re-install.
Microsoft finally creates their first 64 bit version of the Access ODBC drivers
To our knowledge, until July 2013, Microsoft has never released a 64 bit version of their popular Access ODBC drivers that allows 3rd party applications such as Web+Center to connect with an Access Database on a 64 bit machine in 64 bit mode. This forces Web+Center users who migrated to 64 bit Windows OS platforms to run their IIS web servers in 32 bit mode to be compatible with the 32 bit ODBC database drivers that connect to those applications. Read the article below to find out how you can download and install the 64 bit drivers when migrating, upgrading or installing Web+Center on 64 bit Windows Operating systems. This additionally might be helpful for other applications that may require this 64 bit ODBC Access driver.
Sincerely,
Scott Vanderlip
President, Internet Software Sciences
64 Bit Access ODBC Drivers
32 bit versus 64 bit compatibility is very important when running Web applications running under IIS. We wrote a special newsletter article about these 32/64 bit compatibility issues back in 2009 with newsletters #57.
The basic summary of this 32/64 bit 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 providing updates in 64 bit compatible formats while the critical 64 bit Access ODBC database driver component from Microsoft was never released until July 2013 from what we can tell. Even now (March 2014), this 64 bit ODBC driver is not part of the installed OS and must be installed separately and has some other restrictions (see below).
Web+Center supports 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 windows Operating systems which is the default, special install instructions were required to run ISS webserver in 32 bit mode and find a hidden 32 bit version of the ODBC driver for Access.
Some exceptions: There appears to be some restrictions from Microsoft on whether you can install this new driver on a 64 bit that already has Access drivers installed. Here is the note they provide on their download page:
Note: Before installing this download, you must first remove any previous versions of the Access Database Engine from your computer by using Add/Remove Programs in the Control Panel.
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.
Summary
Now that this option is available from Microsoft, we will be offering this option in 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.
Article by Scott Vanderlip