SPSS v.27 64-bit and MS Access 32-bit?

Posted by ariel barak on
URL: http://spssx-discussion.165.s1.nabble.com/SPSS-v-27-64-bit-and-MS-Access-32-bit-tp5740371.html

Hi All,

I'm currently using a 32-bit installation of SPSS v.26 on a 64-bit Windows 10 Enterprise OS with 32-bit Microsoft Office applications (Excel, Acces, etc.). I'm interested in upgrading to v.27 but now understand that it's only available as a 64-bit application. While most of the data sources I use are either SQL Server databases or Excel files, I do query a few Access databases that are 32-bit. Due to compatibility issues etc., switching these over to 64-bit MS Access is not an option.

IBM Tech Support said  "If you are upgrading to the latest version of SPSS 27, then upgrading to 64-bit applications will be necessary for compatibility to be successful." They also provided this link - https://www.ibm.com/support/pages/bit-version-and-odbc-connectivity-ibm-spss-statistics-modeler

Are folks able to use ODBC drivers querying tables from 32-bit Access databases with the 64-bit version of SPSS v.27?

Are there any simple workarounds to this bit-compatibility issue?

Does IBM expect that all SPSS users are now using 64-bit installations of MS Office products?

Any help would be greatly appreciated.

Thanks,

Ariel

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD