Complied Access Runtime on Win10 ADO v10.0 wont run on Windows 8.1 ADO v6.x (1 Viewer)

SuperShin

Member
Local time
Today, 09:57
Joined
Feb 16, 2020
Messages
33
So I have an access runtime project that I deploy out, it runs on the 2016 RTE

I get errors with Left() functions and I just know its a tell tale sign of .dll versioning problems because other parts of the software runs fine its not that a .dll or .ocx is flat missing.

Customer has

No full office install onlyl the 2016 RTE and windows 8.1

ADODB: C:\Program Files (x86)\Common Files\System\ado\msado15.dll (6.3.9600.16384)
ADOX: C:\Program Files (x86)\Common Files\System\ado\msadox.dll (6.3.9600.16384)
stdole: C:\Windows\SysWOW64\stdole2.tlb (6.3.9600.16384)

I compile on Windows 10 and have
ADODB: C:\Program Files (x86)\Common Files\System\ado\msado15.dll (10.0.19041.746)
ADOX: C:\Program Files (x86)\Common Files\System\ado\msadox.dll (10.0.19041.746)
stdole: C:\Windows\SysWOW64\stdole2.tlb (10.0.19041.1)

Now I believe this is the issue, I remember back in the eraly days when Microsoft flat out broke ADO because of changing class registration GUID I was involved quite a bit in those Microsoft forums, one hack at the time before they fixed it was to copy over and register the new .dll to an older machine.

I can't accomplish that copy paste on the 8.1 when i copy and paste it gives me the UAC popup for permission required I say yes but then it says access denied, so that's wierd. To my knowledge there is no Microsoft Installer for V10 ADOX since its part of the OS but why isn't it backward compatible?

do I need to unregister the target machine 6.3 and regsvr the other dlls somewhere else?

Any help is appreciated!
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 08:57
Joined
Feb 28, 2001
Messages
26,999
I would hope that you remembered to "Run As" Administrator when trying to do this copy & paste operation?

As to "why isn't it backwards compatible" the only answer is that MS long ago decided to give themselves a free pass on backwards compatibility at that level. I may be a bit cynical about this, as you suggested early in your question, going backwards is a no-no for many Office products when you involve VBA code and specific libraries.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 09:57
Joined
Feb 19, 2002
Messages
42,970
Without a full version of Access, you can't identify the missing library. Open the version at your PC and copy down the names and locations of all the references. Then go to that computer and try to find them all.
 

SuperShin

Member
Local time
Today, 09:57
Joined
Feb 16, 2020
Messages
33
Without a full version of Access, you can't identify the missing library. Open the version at your PC and copy down the names and locations of all the references. Then go to that computer and try to find them all.

Thanks for the comment guys, I appreciate any help even bouncing ideas.

Yes that's what I can do for sure, I've been developing in Access for about 20 years so that standard error message definitely tends to mean your .ade just isn't compiling right because of a missing OCX or DLL, so i implemented an info screen on my program that lists all references with version and locations, here is his pc win 8.1 vs my pc win 10 I made sure that even with an RTE i could get this info

Code:
Windows 8.1 PC (NOT WORKING)
16.0.4288.1000

Microsoft Access 2016 - Build:16.0.4288 Run-time

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.9600.17728)
WIA: C:\WINDOWS\System32\wiaaut.dll (6.3.9600.16384)
WinHttp: C:\WINDOWS\system32\winhttp.dll (6.3.9600.16384)
AccessRotateText: C:\Program Files (x86)\Tournament In A Box\System\RotateLabelVer2.ocx (1.0.0.141)
BARCODEWIZLib: C:\Program Files (x86)\Tournament In A Box\System\BarcodeWiz.dll (4.0.0.0)
ADODB: C:\Program Files (x86)\Common Files\System\ado\msado15.dll (6.3.9600.16384)
ADOX: C:\Program Files (x86)\Common Files\System\ado\msadox.dll (6.3.9600.16384)
stdole: C:\Windows\SysWOW64\stdole2.tlb (6.3.9600.16384)
MSXML2: C:\Windows\SysWOW64\msxml6.dll (6.30.9600.17041)
MSComctlLib: C:\WINDOWS\SysWOW64\MSCOMCTL.OCX (6.1.98.39)
Office: C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\MSO.DLL (16.0.4288.1000)
VBIDE: C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB (7.1.10.48)
VIDEOCAPLib: C:\Program Files (x86)\Tournament In A Box\System\videocap.ocx (11.1.1.0)


Windows 10 PC (My Development Machine)
16.0.14131.20332

Microsoft Access 2016 - Build:16.0.14131

VBA: C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLL (7.1.11.10)
Access: C:\Program Files (x86)\Microsoft Office\root\Office16\MSACC.OLB (16.0.10001.10000)
DAO: C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\ACEDAO.DLL (16.0.14131.20332)
SHDocVw: C:\Windows\SysWOW64\ieframe.dll (11.0.19041.964)
WIA: C:\Windows\System32\wiaaut.dll (10.0.19041.746)
WinHttp: C:\Windows\system32\winhttpcom.dll (10.0.19041.1)
AccessRotateText: C:\Program Files\Tournament In A Box\System\RotateLabelVer2.ocx (1.0.0.141)
BARCODEWIZLib: C:\Program Files\Tournament In A Box\System\BarcodeWiz.dll (4.0.0.0)
ADODB: C:\Program Files (x86)\Common Files\System\ado\msado15.dll (10.0.19041.746)
ADOX: C:\Program Files (x86)\Common Files\System\ado\msadox.dll (10.0.19041.746)
stdole: C:\Windows\SysWOW64\stdole2.tlb (10.0.19041.1)
MSXML2: C:\Windows\SysWOW64\msxml6.dll (6.30.19041.906)
MSComctlLib: C:\Windows\SysWOW64\MSCOMCTL.OCX (7.0.55.3227)
Office: C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\MSO.DLL (16.0.14131.20332)
VBIDE: C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB (7.1.10.68)
VIDEOCAPLib: C:\Program Files (x86)\VideoCap Live ActiveX Control\videocap.ocx (11.1.1.0)

As you can see all the registered components on both machines are identical but the version of ADO is not the same nor stdole2.tlb
 
Last edited:

Pat Hartman

Super Moderator
Staff member
Local time
Today, 09:57
Joined
Feb 19, 2002
Messages
42,970
The app isn't going to work without the correct libraries. Can you update the libraries on the target PC? I almost never use ADO. Access is optimized for DAO so I stick with that even when the BE is ODBC. I know for a couple of years there was some confusion but MS has settled on DAO for now.
 

SuperShin

Member
Local time
Today, 09:57
Joined
Feb 16, 2020
Messages
33
Yeah I think at this point the problem is the PC, because I cannot unregister C:\Program Files (x86)\Common Files\System\ado\msado15.dll even though I use an admin cmd prompt and it says succeeded.

I cannot register my own version of msado15.dll (v10) even though i use a command prompt and it says it succeeds. I cannot overwrite the .dlls in the target director of C:\Program Files (x86)\Common Files\System\ado\ even though I'm running as a administrator.

UAC is turned off and when it asks says i need elevated permissions I say yes and still get a permission denied.

I even used his "admin" account to make a new administrator and tired it no luck
 

Users who are viewing this thread

Top Bottom