Is Office Accounting a 32 bit Application? Does it work 64 bit operating systems and 64 bit SQL?

Yes, yes and no. Some of you have tried to install Office Accounting on a 64 bit operating system (fine), maybe even on 64 bit SQL Server (not so fine). So why is Office Accounting a 32 bit application? Doesn't Microsoft know how to compile in 64 bit? Well we do.

One of the strengths of Office Accounting is the integration with other applications and services, such as other Office applications, payroll, eBay listing (US), Bacs e-payments (UK), import from Microsoft Money and Intuit QuickBooks (US), etc.

Most of the integration components are in 32 bit and the code is written in-process, so this is not going to work in 64 bit (as you cannot mix 64 and 32 bit in-proc). We will basically have to rewrite most of the integration code to run out-of-process in order to ship in 64 bit.

Fine, the app is 32 bit, but why can’t I use 64 bit SQL? As all of the Office Accounting engines (posting, tax/VAT, FIFO, foreign currency) are written in SQL and reside as stored procedures within the database, the database has to 32 bit as well (in order not to mix 32 and 64 bit in-proc).

So for now you will have to run Office Accounting on 32 bit SQL Server on a 32 or 64 bit operating system.

Comments (5)

  1. chrisbonduk says:

    Bit confused.  Take a multi-user setup where sql server is running SQL 2008 64bit edition on windows server 2008 64bit.

    The workstations are 32bit (xp or vista), can you install the database to the above setup?

    From looking at the database it doesnt use Assembly’s so I cant see any reason why it cant from there……  

  2. jthuneby says:

    The problem here is that we do hit the database directly with some of our code, so while you can RUN OA on a 64 bit SQL 2008 (I am on a test box), you cannot create a new company, use the DB utilities or any feature that requires backup.

    So if you REALLY want to do this, you can create a company on 32 bit SQL, back it up with SQL Server Management Studio, restore it on a 64 bit SQL and modify your company file to point to the new DB instance.

    However you will have to use SQL Management studio for future backups and future service packs may not work.

  3. bricomp says:

    Office 2010 64-bit, BCM 2010 64-bit and Accounting 2009 (on a remote 32-bit SQL server) – do they play together? Will I all features such as submitting time still function? Everything under 2007 s4-bit worked just fine.

  4. BajaDude says:

    I can't even get the installer to run on my new 64-bit Win7 system. It worked fine with Win7 on my old 32-bit laptop. What am I doing wrong?

  5. For some reason my Paypal integration does not work on my 64bit system.

    The paypal addin does not show up. I have uninstaleld and re-installed the addin.

    anyone else.

Skip to main content