Compile error due to 64-bit version of Microsoft Excel

From ODBClink wiki
Jump to navigation Jump to search

IMPORTANT NOTE

THIS ARTICLE ONLY APPLIES TO ODBCLINK OLDER THAN V3.46.0.113

Overview

Start-Up compile error

While ODBClink can run on Microsoft Excel 2003, 2007, 2010 and 2013, it used to require the 32-bit version of those products to be installed. The main reason for this was that both the MYOB ODBC driver and the QuickBooks QBFC object library are 32-bit only.

Note that ODBClink can run on 64-bit machines, but Microsoft Office must be 32-bit. If you tried to run ODBClink on a 64-bit version, you would receive a compile error when ODBClink first start.

Also note that Microsoft Excel 2003 and 2007 are only available as 32-bit versions and are not affected by this issue.

If you do have Microsoft Office installed as a 64-bit version, you may need to uninstall it and install the 32-bit version which is located on the same disk.

How to check the version of Microsoft Excel 2010

Checking the version of Microsoft Excel 2010
  1. Start Microsoft Excel;
  2. Click on the File button;
  3. Click on the Help entry in the list;

The full version number, including 32-bit or 64-bit version is listed on the right hand side of the screen.


How to check the version of Microsoft Excel 2013

Checking the version of Microsoft Excel 2013
  1. Start Microsoft Excel;
  2. Click on the File button;
  3. Click on the Account entry in the list;
  4. Click on the About Excel button;

The full version number, including 32-bit or 64-bit version is listed in the first line.


Related Topics