It could be the 64 bit Excel.  Have you tried it with 32 Bit Excel?  I've had issues with 64 Bit Excel and SAGE Intelligence that was resolved with 32 Bit Excel...

I am trying to confirm that we must go back to 32-bit before we do this. I know it works with 32-bit.

Hi,  No, you do not have to go to 32-bit office to use BIE.   Sage 100 2014 BIE is compatible w/Office x64.

Can you provide details on the issue you are experiencing?

What Version of Office is being used?

What SP is installed on Sage 100 2014

What OS is the TS?

The only issue I am aware of is detailed below.

KB 53091

MS Office 2013 64 bit users are now able to export data to Microsoft Access Database (.accdb) from Business Insights Explorer. Users may run into issues if the 2010 access drivers have not been installed. To correct this, download and install the following:

www.microsoft.com/.../details.aspx

Thanks

John Nichols

Sage  

John,

I am the consultant working with Jerry on this incident.  I saw the Sage KB article about this 32 bit MS Access Database and I downloaded it and tried to install it.  I received an error saying:

You cannot install the 32-bit version of Microsoft Access Database Engine 2010 because you currently have 64-bit Office products installed.  If you want to install 32-bit Microsoft Access Database Engine 2010, you will first need to remove the 64-bit installation of Office products.  After uninstalling the following product(s), rerun setup in order to install 32-bit version of Microsoft Access Database Engine 2010:

Microsoft Office Standard 2010

This appears to be saying that we must uninstall the 64-bit before installing this 32-bit engine.  This leads me to believe that they are incompatible.

They currently have MS Office 2010 on a terminal server running Windows Server 2008 R2 Enterprise.

John,

I am the consultant working with Jerry on this incident.  I saw the Sage KB article about this 32 bit MS Access Database and I downloaded it and tried to install it.  I received an error saying:

You cannot install the 32-bit version of Microsoft Access Database Engine 2010 because you currently have 64-bit Office products installed.  If you want to install 32-bit Microsoft Access Database Engine 2010, you will first need to remove the 64-bit installation of Office products.  After uninstalling the following product(s), rerun setup in order to install 32-bit version of Microsoft Access Database Engine 2010:

Microsoft Office Standard 2010

This appears to be saying that we must uninstall the 64-bit before installing this 32-bit engine.  This leads me to believe that they are incompatible.

They currently have MS Office 2010 on a terminal server running Windows Server 2008 R2 Enterprise.

John:

The KB article says this is a problem with Office 2013 64-bit. Is it also a confirmed problem with Office 2010 64-bit? The latter is what we are dealing with.

Hi,

Can you provide details on the issue you are experiencing?

There is a 64 bit version of the of the Microsoft Access Database Engine 2010 Redistributable

www.microsoft.com/.../details.aspx

Thanks

John Nichols

Sage

As Chuck explained, the 32-bit DB Engine won't install. It throws an error message (which I would post, but this forum doesn't permit attachments(!?). "You cannot install the 32-bit version of MS Acces db engine 2010 because you currently have 64-bit Office products installed...."

According to Sage KB 30531, for Office 2013 64-bit: "Select AccessDatabaseEngine.exe (x86 version of drivers)"  No mention of either Office 2010 64-bit or db Engine 64-bit. 

If the 64-bit DB Engine will work with 2010, why doesn't the Sage KB article say so? Please confirm.

There is a 64 bit version of the of the Microsoft Access Database Engine 2010 Redistributable

www.microsoft.com/.../details.aspx

I'll have the KB edited.  

Thanks

John Nichols

Sage

We downloaded and installed the 64-bit version. No errors on install, but BIE still does NOT work.

Suggestions?

Hi

Can you tell me specifically what in BIE is not working?

Please provide the "file version" of   (Right click Properties |Details)

C:\Program Files (x86)\Common Files\Sage\Common Components\Exapp.exe

I'll be glad to take a look. Thanks John

Hi,

"You cannot install the 32-bit version of MS Acces db engine 2010 because you currently have 64-bit Office products installed...."

What this means is you have installed the x64 Microsoft Access Database Engine Drivers.  Uninstall them using Control Panel | Programs and Features.  Reinstall the x86 (32bit) bit version of the Microsoft Access Database Engine Drivers.   I have verified they do install if you don't already have the x64 drivers installed.  Sorry for the confusion.

Thanks

John Nichols

Sage

Thanks, John,

The underlying problem is that the menu choice to export any BIE query to Excel has been dsiabled (grayed out).  This happened when the IT people upgraded the terminal server version of Office to 2013 64 bit  They have since rolled it back to 2010 but left it at 64 bit.

The file version of Exapp.exe is 5.0.0.2266.

Hi,

Do you have an open case with support that I can tag to have them provide the current Exapp.exe?

Thanks John Nichols

Sage

Current Version is 5.0.0.2284

No, we did not. We figured that we were either looking at a fundamental, known incompatibility around 64-bit Terminal Services, or some detail that we missed.

It turns out that it is an UNknown incompatibility. We gave up and simply installed the 32-bit version. The trial and error was too much for our customer and its IT vendor to put up with. If you have special instructions, they should be placed in the upgrade document, not scattered across quasi-correct Sage KB articles.