Is it possible that you have the Access DB engine installed? I seem to recall conflicts with it will still refer to Office components being the issue. To get rid of it you have to run the AccessDatabaseEngine_x64 exe and the option to remove it will come up.
Go to control panel/uninstall a program/ and uninstall the Microsoft Access Database engine 2010 Redistributable, then go to Microsoft and download it again, this time download the 32bit. Then reinstall the office. I hope in works!
We currently have a major issue using Microsoft Access Database Engine 2010. The engine comes in 64-bit and 32-bit forms, which is good. However, apparently you need to always install the 32-bit version if the host process is always 32-bit. Fine, we can do this.
Our software deals with a lot of legacy components that are 32-bit, and much of it is in VB6 code, which generates 32-bit assembly. So, we are under the assumption that the driver must also be installed as 32-bit. Indeed, when we install 32-bit drivers on a 64-bit machine, and run our 32-bit applications, it works correctly.
However, the problem begins when Office 2010 64-bit is installed on the system. Trust me, we've tried to educate users that 64-bit Office is largely unnecessary, to no avail. As computers come off the assembly line with 64-bit versions installed, we're unable to keep up with support requests when our software breaks something. Either the 64-bit Office breaks our installation, or our installation breaks their Office version, but it's not pretty either way. A further issue is that non-legacy software will sometimes install the 64-bit drivers (as they should), and the two versions simply do not coexist in any reasonable manner. Either our software breaks, or their software breaks.
So, has anybody managed to find a way to make the 32-bit drivers coexist with 64-bit installations? I have seen that installing with /passive flag allows the two to be installed, and our installer does use passive. Both are being installed, but once on the system either our software no longer works, or Office constantly repairs its installation. Is there any reasonable way to make this work?
Now you can start a 32-bit MS Office application without the "re-configuring" issue.Note that the "mso.dll" registry value will already be present if a 64-bit version of MS Office is installed. In this case the value should not be deleted or renamed.
You can now use this file to install the Microsoft Access Database Engine 2010 redistributable on a system where a "conflicting" version of MS Office is installed (e.g. 64-bit version on system with 32-bit MS Office version)Make sure that you rename the "mso.dll" registry value as explained above (if needed).
I hate to answer my own questions, but I did finally find a solution that actually works (using socket communication between services may fix the problem, but it creates even more problems). Since our database is legacy, it merely required Microsoft.ACE.OLEDB.12.0 in the connection string. It turns out that this was also included in Office 2007 (and MSDE 2007), where there is only a 32-bit version available. So, instead of installing MSDE 2010 32-bit, we install MSDE 2007, and it works just fine. Other applications can then install 64-bit MSDE 2010 (or 64-bit Office 2010), and it does not conflict with our application.
Check the "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPaths" registry key and make sure the value "mso.dll" is NOT present. If it is present, then Office 64-bit seems to be installed and you should not need this workaround.
If both versions of Microsoft Access Database Engine 2010 can't coexists, then your only solution is to complain to Microsoft, regarding loading 64 bits versions of this in your 32 bits app is impossible directly, what you can do is a service that runs in 64 bits that comunicates with another 32 bits service or your application via pipes or networks sockets, but it may require a significant effort.
CIT programs strive to transform the crisis response system - minimizing the times that law enforcement are the first responders to citizens in emotional distress. They also aim to ensure that law enforcement agents have the knowledge, skills and support to de-escalate situations and divert individuals from the criminal and juvenile justice systems, when appropriate.
MAP is a collaboration between the criminal justice system and mental health system. With an iPad App police officers can remotely connect an individual to a Mental Health Professional without taking that individual to a different location such as the hospital or jail.
Knowing your version helps you choose compatible software add-ons and plugins. Plus, some features may vary between different architectures. So, being aware of your version makes for a smoother experience.
Fun fact: Microsoft Office 1.0, the first-ever office productivity suite, was only available as a 16-bit release for Windows! It included popular applications like Word, Excel, and PowerPoint which revolutionized document creation and data management.
Which version should you choose? If you work with complex files, large databases or memory-intensive tasks, go for the 64-bit version. It provides greater stability and capability to manage large data.
On the flip side, if you use Office mainly for basic activities like writing and creating presentations, the 32-bit version should suffice. It is also compatible with most add-ons and external programs.
To check your Microsoft Office version, utilize the following solutions: Using the File Options and Using the Control Panel. The File Options method allows you to access version information directly within the Office application, while the Control Panel method provides a system-wide view of all installed versions.
What's the latest word on Sage 300 and Office integration? Today we are running Sage 300 2018 and we are currently limited to Office 2019 32-bit. We are upgrading to Sage 300 2021 this spring but it doesn't appear that Sage 300 2021 supports 64-bit Office. Is that right?
Has there been any discussion about supporting 64-bit Office? or any options for those companies that don't have a choice due to other requirements in their infrastructure? Maybe workarounds or optional configurations?
I was afraid you'd say that, although not surprised. As a systems admin, the default configuration is always the easiest to support and lately that has been 64-bit Windows + 64-bit Office. I'd just as soon maintain one base image with Windows/Office 64-bit.
On a side note, we have several 32-bit apps that seem to integrate fine with 64-bit Office. Adobe Acrobat, Mitel and Zoom come to mind. Tight Office integration between 32-bit apps and 64-bit Office. Seems doable with 32-bit Sage as well.
My understanding is the later versions of S300 works fine with x64 of Office and it comes down to more a matching of system privilege's between the two systems. Like you cant have S300 running with admin privilege's and office not or vice versa. Or even running as Admin in either may cause Office to spit the dummy.
Sage 300 is a 32 bit application, it will never talk to Office 64 bit. Not unless Sage 300 is rewritten in 64 bit, but that is not going to happen. With that said.... you can export/import data no matter which Office 32/64 bit you have installed, you just cannot run FR and some other integrations that require both applications to be 32 bit.
by the Sage 300 support team, who advised that MS Office doesn't have an option to mix and match 32bit apps with 64bit versions of apps.
The team also recently posted a blog for Sage 300 version 2022 (6.9) titled After upgrading Microsoft Excel to 64bit, Financial Reporter returns error with Excel Add-in. which gives steps on how to ensure a proper 64bit install of Microsoft Office. Hope this helps!
My question was specifically about Sage's support of the Office 365 version of Microsoft Office (as opposed to Office 2016 and Office 2019). To clarify, can you please ask the Sage 300 support team the following two questions?
I can confirm that on 2022 PU4, you can run 64-bit office, not only with Financial Reporter, but with custom VBA programming. We upgraded one of our big clients last week, and they're happy that 64-bit Excel finally runs.
The only issue I had was with VBA forms that had a Fieldedit control and a Datasource. The Datasource control is not currently available in 64-bit. The KISS solution for my client was to abandon the pretty finder and use a simple text field for them to type in the vendor number.
I was able to get the Financial reporter running but the Sage macros would not run. the VBA would not initiate or even give an error message when attempting to run any macro. Sage intelligence also did not run correctly and would not initiate running a report.
As a test we uninstalled the 64 bit Office and installed 32 bit office and everything ran correctly. This tells me that Sage 300 is NOT compatible with 64 bit office. It will not allow any out of the box macros run or any customer macros.
My old comments haven't aged well, because I know now that macros will run on 64-bit, we just converted our Acumen tools to run on either 32 or 64 bit. What doesn't work in 64-bit is data source controls on forms, so our nice finder forms got broken. We just replaced them with regular VBA list boxes. We use this to tell what version we're running:
Our New York office works both in the United States and internationally. Our partners include governments, philanthropies, multilaterals and non-profits. In the United States, we work with all levels of government, from local and city partners to state and federal agencies. For example, we have helped more than 50 cities across the US apply behavioral insights through the What Works Cities initiative. Internationally, we work with national governments, NGOs and major multilateral organizations to address issues ranging from humanitarian relief to environmental sustainability.
d3342ee215