DLL Hell ... Again Access 16.0.12430.20264 vs 16.0.4266.1001 Office 365 vs ACCDR RTE Project
Hi everyone first time poster long time access developer, a few years ago I had this issue, and a year or so ago I had this problem. I develop a 32bit access .accdr and distribute it via the runtime with an installer. Client has Click to Run Office 365 (32bit) 16.0.12430.20264 My version of access if Office 2016 16.0.12430.20264. When I deploy my app to their PC the run time does not install (obviously since they have 365) however when I try to run portions of my form I get errors like function is not available in expressions in query expression left([id],1) Now Other 365 users dont have this problem just this client what can I do here? Here are my references: 16.0.4266.1001 Microsoft Access 2016 - Build:16.0.4266 VBA: C:\PROGRA~2\COMMON~1\MICROS~1\VBA\VBA7.1\VBE7.DLL (7.1.10.48) Access: C:\Program Files (x86)\Microsoft Office\Office16\MSACC.OLB (16.0.4266.1001) DAO: C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\ACEDAO.DLL (16.0.4266.1001) SHDocVw: C:\Windows\SysWOW64\ieframe.dll (11.0.18362.657) WinHttp: C:\Windows\system32\winhttpcom.dll (10.0.18362.1) ADODB: C:\Program Files (x86)\Common Files\System\ado\msado15.dll (10.0.18362.239) ADOX: C:\Program Files (x86)\Common Files\System\ado\msadox.dll (10.0.18362.175) stdole: C:\Windows\SysWOW64\stdole2.tlb (10.0.18362.1) MSXML2: C:\Windows\SysWOW64\msxml6.dll (6.30.18362.418) Office: C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\MSO.DLL (16.0.4266.1001) Here are the client references: 16.0.12430.20264 Microsoft Access 2016 - Build:16.0.12430 VBA: C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLL (7.1.10.92) Access: C:\Program Files (x86)\Microsoft Office\Root\Office16\MSACC.OLB (16.0.10730.20030) DAO: C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\ACEDAO.DLL (16.0.12325.20144) SHDocVw: C:\Windows\SysWOW64\ieframe.dll (11.0.18362.657) WinHttp: C:\WINDOWS\system32\winhttpcom.dll (10.0.18362.1) ADODB: C:\Program Files (x86)\Common Files\System\ado\msado15.dll (10.0.18362.239) ADOX: C:\Program Files (x86)\Common Files\System\ado\msadox.dll (10.0.18362.175) stdole: C:\Windows\SysWOW64\stdole2.tlb (10.0.18362.1) Office: C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\MSO.DLL (16.0.12430.20184) Deploying my app out to users who already have access almost always works as long as its all 32 bit but i've now encountered this type of issue twice where a CTR Office 365 gets dll errors running my app. Any thoughts?