FRx Management Reporter migration Wizard and Office versions 64 bit v 32 bit

Hi folks, here is a situation we have come across with the Migration wizard for FRx Management reporter for Dynamics GP 2010.


Simply stated the issue is this:

The old FRx databases are Microsoft Office Access databases and so the migration wizard needs certain parts of office connectivity to be able to read and convert the old spec sets into the new FRx Management reporter for Dynamics GP 2010 formats (which are now stored in SQL tables).

FRx Management reporter for Dynamics GP 2010. will only install the components for the operating system it is sat on, so if you are 64bit , it will use the 64 bit Microsoft Office 2010 Access components and if you are 32 bit it will use the 32 bit Microsoft Office 2010 Access components. not a problem so far I hear you cry.

Well now factor in the fact that the new word office template email functionality for Dynamics GP 2010 does not work on the 64 bit version of Microsoft Office 2010 and to get round this a lot of partners are installing the 32 bit version of Microsoft Office 2010 onto 64 bit operating systems in order to use the email functionality in Dynamics GP 2010. Couple this with the fact that if you have FRx Management reporter for Dynamics GP 2010 on a 64 bit operating system it will only use the 64 bit Office components, add the fact that you can not have 64bit office components on a machine that already has 32 bit office components and you have a problem. The Migration wizard will not be able to read the Access database.

So there you have the issue , of course it is easily solved simply do the migration on a machine with all 64 bit components (one you are not intending to use the email functionality from) and you will avoid this issue.

This is definitely a case of forewarned is forearmed.