DLL Hell ... Again Access 16.0.12430.20264 vs 16.0.4266.1001 Office 365 vs ACCDR RTE Project

Copper Contributor

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?

0 Replies