I have a MS Access application that calls an Oracle database. The MS Access application can be used in both 32 bit MS Office or 64 bit MS Office. Currently we have two versions of the Application one for 32 bit and one for 64 bit. Currently we do this: qdExtData.Connect = "ODBC;DRIVER={Oracle in OraClient12Home1_32bit};SERVER=CC;UID=ir;PWD= but this only works for 32 bit . For 64 bit MS Office we have to specific the 64 bit "ODBC;DRIVER={Oracle in OraClient12Home1};SERVER=CC;UID=ir;PWD= ?
Is there a way to determine which ODBC driver to call without specifying it in the VB code?