All Things WinBatch > WinBatch

Under the comes back to haunt you category

<< < (2/2)

td:
Drifting a bit off topic but I vaguely remember a "/passive" switch but could be wrong. I tried it with ACE 16 and it doesn't appear to work. There may also be a registry setting you could temporarily rename to get the 64-bit provider to install with the 32-bit install already present.

For some reason, I can install the Office 10 32-bit provider on my system even though I have 64-bit Office 16 Access installed on my system.

You likely already have this figured out but this quick and dirty detects the bitness of the installed provider:


--- Code: Winbatch ---Text = "None"

if RegExistKey( @REGMACHINE, "SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\Engines\ACE", 32) then Text = "32-bit"      ;
if RegExistKey( @REGMACHINE, "SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\Engines\ACE", 64) then Text:=" 64-bt"

Message("ACE Version 12 providers", Text)
exit
The script reports "32-bit" as expected.

td:
This may be obvious but I should have mentioned that "the both" views check is only necessary or informative on 64-bit systems. You can use WinMetrics to sort that out.


--- Code: Winbatch ---if WinMetrics( -3 ) == 5 || WinMetrics(-7) == 2    ; If wow64 or 64-bit winbatch.

stanl:
Thanks for the code. But this does become a moot point. I compiled a WB script 2009-2010: basically did some web-scraping for luxury used cars. The user distributed the exe across Canada to several dealerships. Most had since moved on to licensing more advanced programs but a few remain and function on that exe - they have, however, moved to Office 365 which is 64 bit. I just changed the 12.0 to 16.0 for Provider string and re-compiled in WB 64 and sent out a zipped package [no charge]. The script was actually just a nice-to-have, he makes his $$$ as a consultant with invites to hold seminars. The few tweaks he asked for in the code were handled with his [probably 1 trillion] frequent flyer miles which he freely set us up with to fly to Atlanta while our daughter was a Ph.D. candidate at Emory.


I haven't used WB related to any work or business since 2017... but I have liked this forum and as annoying as I can appear to be will always be a supporter not a detractor.

td:
Since the topics of this forum are all public, a question posted by one can be useful to others even if the original poster does not gain a benefit.

Navigation

[0] Message Index

[*] Previous page