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?
