O365 ProPlus Access 64Bit ODBC to a 32bit Oracle Source RRS feed

  • Question

  • Have been trying to resolve the mismatch architecture error I receive now that I have a 64-bit version of Access and the source I need to connect to is 32 bit. Is there a solution to this other than installing the 32bit version of office onto my machine?

    I can see all of my connections in the ODBC Data Source Administrator Application both 32 and 64 bit. I have already made sure that the 32bit connection connected successfully. It just won't allow me to add data sources into Access using any 32bit DSN connections.

    Is there a way to manually create a connection string or to disguise the 32bit DSN as a 64bit connection for the access application?

    Friday, November 9, 2018 6:18 PM