64 Bit versus 32 Bit

Good afternoon,
    I’m not sure if you can help me, but maybe at least shed some light on things.  I have a MS-Access database used by
6-7different users.  It mostly uses an MS-Access backend, but there are some connections to a PostgreSQL server as
well. It was built with MS-Access 2010 32-bit because we still had a few 32-bit WinXP machines floating around.  I used
thePostgreSQL Unicode driver, version 9.01.01.00, and configured the connection with Window’s ODBC Data Source
Administrator(32-bit).  It has been working for several years. 
    Now that all of the computers have all been upgraded, some of the newer ones are getting Office 365 64-bit
installed. When they open the database with a 64-bit version of Access, the ODBC connections fails.  If I reinstall the
32-bitruntime version of MS-Access to open the file, everything works fine.  However, I have tried installing the
64-bitPostgreSQL driver, version 11.00.00.00, but Access 64-bit still gives me the same error.  The 64-bit ODBC
connectiontest within the ODBC Data Source Administrator (64-bit) says that it is successful, but 64-bit Access still
can’topen it.  I don’t know if I can have both the 32-bit and the 64-bit drivers installed and setup with the same
networkconnections or not.  I’m not sure if there’s anything within the Access database file that’s directing it to use
the32-bit connection, but the 64-bit version of Access doesn’t like it, or what. 
    If you can shed any light on this I would appreciate it.  Might be more of an Access-side question, but I thought
I’dreach out just in case. 

Thanks,

Cevin Moses
cevin@imoses.com
262-203-3895