Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 773
  • Last Modified:

32bit MS Access 2010 on 64 bit

Is it possible to install/run an MS Access 2010 32 bit application on a 64 bit machine running MS Office 64 bit? Has anyone successfully done this?
0
KnowledgeWare
Asked:
KnowledgeWare
  • 4
  • 3
  • 2
  • +3
2 Solutions
 
tipsybroomCommented:
there should be no problem with this
0
 
KnowledgeWareAuthor Commented:
OK, but have you actually done it? I'm reading about lots of issues with this on web posts, not with the unpackaged file but with compiled accde files. Can you install and run a 32 bit MS Access accde on a 64 bit machine running MS Office/Access 64 bit?
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Depends on the application.  If it uses API calls, 3rd party controls, type libs, or COM objects,  then it will not run without modification.

All 32 bit API calls would need to be adjusted for 64 bits (because it's 64 bit Office, not because of the 64 bit OS) and you'd need 64 bit versions of any type lib or COM object you use.

I would if you can avoid it, not use 64 bit Office.  All it really gives you is larger spreadsheets in Excel.

Even Microsoft still recommends the 32 bit version unless you need this.

If you do want to use Office 64 bit anyway, I would check the code using this:

Microsoft Office Code Compatibility Inspector user's guide
http://technet.microsoft.com/en-us/library/ee833946.aspx

also read:

 Compatibility Between the 32-bit and 64-bit Versions of Office 2010
http://msdn.microsoft.com/en-us/library/ee691831(office.14).aspx

and section "Introducing the VBA 7 Code Base"

All the new 64 bit calls are here:
http://www.microsoft.com/download/en/confirmation.aspx?displaylang=en&id=9970

and here's a list of all the calls that were modified for 64 bit:
http://msdn.microsoft.com/en-us/library/aa383663(VS.85).aspx

Jim.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
terencinoCommented:
Deleted...
0
 
peter57rCommented:
I thought that it was impossible to load 32 bit AND 64 bit Access on the same machine?

It's certainly what MS says.
0
 
terencinoCommented:
Maybe I deleted my previous comment too soon. I have Windows 8 64-bit with Office 2013 64-bit installed and 32-bit Office installed over it. While I'm not recommending it, and I'm sure it will end in tears, the applications seem to work fine. I can even run both versions of Outlook, although only one at a time. The only annoyance is the configuration process takes about 15 seconds each time you change Access versions.

The install programs for 2010 won't allow 32-bit and 64-bit Office of 2010 to coexist on the same machine though.

...Terry
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I thought that it was impossible to load 32 bit AND 64 bit Access on the same machine?
That's my understanding as well, and it seems to be confirmed by this:

The 64-bit version of Office 2010 is not compatible with any other 32-bit version of Office programs.
From here: http://office.microsoft.com/en-us/word-help/choose-the-32-bit-or-64-bit-version-of-office-HA010369476.aspx

That said, you can install different VERSIONS of Office, and those versions could be different - so in the case of the author's environment, looks like they're running 2013 and 2010.  Those could be different versions, of course.
0
 
KnowledgeWareAuthor Commented:
Thanks to all, I'm splitting up the points, thanks again. Not want I wanted to hear however!
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
um.. I'm a little confused; are you worried about the Office installs themselves, or running an application (a DB) in the situation you described in the question?

Jim.
0
 
KnowledgeWareAuthor Commented:
Hello Jim - I'm worried about running a proprietary MS access 2010 32 bit application, not worried about the office installs, but of course I don't want to break them with our install!
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<Hello Jim - I'm worried about running a proprietary MS access 2010 32 bit application, not worried about the office installs, but of course I don't want to break them with our install! >>

 That being the case, the accepted answer doesn't deal with that (and is where my confusion came in).

 LSM was talking about Office installs, not running an application within Access.

  You can write a DB in such a way that it will run under 32 or 64 bit Access as long as you don't use 32 bit specific controls or type libs.    API calls be setup for both (requires compiler directives).

 So in short, some can and some can't.

Jim.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Agreed - it does not seem my comments addressed your issue, so we should reopen this, and Jim's comments should be accepted instead.
0
 
KnowledgeWareAuthor Commented:
Thanks to all.... I think I've finally learned how to award points... (how embarrasing!). All comments appreciated. We'll look at producing a 64 bit version.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 4
  • 3
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now