Is Office Accounting Professional 2009 Compatible with Office 2010

Discussion in 'Microsoft Accounting' started by Boolean1, Jun 11, 2010.

  1. Boolean1

    Boolean1 Guest

    If I un-install Office 2007, and install Office 2010 64-bit, will I still be
    able to export invoices and reports from Office Accouting to Word / Excel?

    (I using a Windows 7, 64-bit operating system.)

    Boolean1, Jun 11, 2010
    1. Advertisements

  2. Boolean1

    icreateofx Guest

    There have been documented incompatibilities between Office 2010 and Office
    Accounting. It has not been officially deemed incompatible by Microsoft,
    though I would not rely on such an installation for critical business data.

    I STILL use Office 2007 with BCM and Office Accounting Pro 2009, and will
    continue doing so for the fore-seeable future. I simply cannot find ANY
    product on the market to match the functionality and simplicity of use that
    this combination offers for the cost. Nearest would be SAP Business One on
    functionality and ease of use but NOT cost.
    icreateofx, Jun 11, 2010
    1. Advertisements

  3. Boolean1

    rodwhiteley Guest

    I had an issue with the templates when using Office 2010 and Windows 7. My
    suspicion is that the filepath has changed with the slightly different
    conventions in windows 7 (Documents Libraries versus My Documents) which
    means I have to export all receipts to Word to print. Things seem to work
    better with Office 2007 than 2010, so I uninstalled 2010 and went back to
    2007 for the computer using Office Accounting.
    Hope this helps,
    rodwhiteley, Jun 13, 2010
  4. Boolean1

    rodwhiteley Guest

    rodwhiteley, Jun 14, 2010
  5. Boolean1

    WillFa Guest

    The one issue that we encountered is that since MS lost the i4i patent
    lawsuit regarding Custom XML, your templates will not work if they've been
    modified and saved in Word 2007/2010 format. Re-save your templates in Word
    97-2003 format (*.doc) for them to work.

    If they're saved in *.docx, *.doct, or *.docm format; Word will strip out
    all the little pink tags in the document and you'll be left with the
    [Placeholder Text] and not actual database values.
    WillFa, Jun 24, 2010
  6. Boolean1

    Paul Guest

    Not a complete answer but from what I have read you might want to install
    Office 2010 in 32 bit mode to allow for compatibility with the various
    plug-ins that integrate everything into office; there may be some problems
    running 32bit plug-ins with 64bit Office software.
    Paul, Jun 30, 2010
  7. Boolean1

    Peter Guest

    Yes seems to have a problem using Access 2010 64bit with any Access 32-bit;
    no solution seen at present with .mde
    Peter, Aug 22, 2010
  8. Boolean1


    Jun 3, 2011
    Likes Received:
    The answer

    If you upgrade to Office 2010, you will lose the XML functionality, which allows you to export to word. Microsoft was in a lawsuit, which deemed the XML tags Office Accounting was using, to be proprietary. So before Office 2010 was actually shipped, the XML capabilities were stripped out.

    If you do upgrade to Office 2010, do not open your custom templates and then save them. The XML will be stripped and no data will come across. You will want to uninstall Office 2010 as well as deleting the OFFICE14 folder in the registry. (Office Accounting looks for this reg key and attmepts to export to the newest version of Word). By deleting that key, Office Accoutning will again export to Office 2003/2007... whatever the newer installed version is.

    Here is the exact location of the registry key that needs to be deleted (after uninstalling Office 2010):

    1) Click "Start" and then click "Run".
    2) Type in regedit and then click "OK".
    3) Navigate here:


    4) Delete the "14.0" folder.
    NOTE Microsoft skipped the number 13... just an interesting fact.
    5) At this point, I would restart to refresh the registry, then run a repair on your previous version of Office. (from add-remove programs or by inserting the 2007/2003 CD)
    6) Export from Office Accounting as normal.
    Answer, Jun 3, 2011
  9. Boolean1


    Jul 10, 2011
    Likes Received:
    There is a way round this that doesn't involve reinstalling Word 2010 or editing the registry - well, it worked for me. The trick seems to be to get Word to access the XML schema provided by Accounting 2009. Summary as follows:

    1. Ideally find an unedited Accounting 2009 template file that retains the schema links (see later). It doesn't matter which template it is, but it saves effort later finding the XML schema file
    2. Save it as a new template in Word 97-2003 format
    3. Put Word 2010 into 'developer' mode (File > Options > Customise Ribbon to display it on the Ribbon)
    4. Select 'Structure' (on the XML tab) and select 'Design Mode' (Controls tab)
    5. An XML Structure pane should have opened on the RHS of the Word window. If not (esp if you've not managed to find an unaltered template file per step 1), you will need to select 'Schema' (XML tab) and hunt through your system for the Accounting 2009 XML schema. I didn't have to do this, so can't help much more
    6. Assuming you've got a valid schema open, untick the box at the bottom of the XML Structure pan entitled "List only child elements of current element". This should then bring up a list of all the placeholders from Accounting 2009, which you can then insert into your document as you like
    7. Edit the template, inserting fields as required, and save in 97-2003 format in the Accounting template folder.


    AndrewR, Jul 10, 2011
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.