Top Contributors

Coding for 32 Bit and 64 Bit

So for arguments sake can you code for an application to operate in both 32 and 64 bit environments?  One application that can be loaded on either 32 or 64 bit.  Much like loading 64 bit Windows and using 32 bit Office.

I dabbled with the process a while back with Office 2010 and 2013 both 32 and 64.  I was able to upgrade the application to use 64 bit but when it was loaded on a machine that had 32 bit office it wouldn't work.  I suspected it wouldn't because it didn't have the 64 bit libraries.  But could you include the libraries as part of a runtime so it could work on either 32 or 64 bit?

Just thinking...

Rank: Genius

Expert Comment

Nick672015-01-08 11:16 AMID: 140887
There are no 64 bit JET drivers.
There have been a bunch of Q's lately about 32-bit and 64-bit ODBC issues (ultimately, the end problem)
Other folks may chime in, but it's much like trying to distribute a DSN-less app.
Your VBA is not a good place to query the registry for what system drivers are in place and try to adapt on the fly.
To do it well, you'd really have to distribute a complete .msi package, I think.

Author Comment

John Sheehy2015-01-08 12:17 PMID: 140905
So why offer a 32 bit and 64 bit version?  Can you code a 32 bit application in 64 bit access and it work?
Rank: Genius

Expert Comment

Nick672015-01-08 12:33 PMID: 140908
I suspect that if you have no FE/BE, Just a single accdb with no ActiveX controls of any sort, that It would work on any bits and any version of Access after 2007.
You've dabbled.
Is that not so?
Even now, very few folks are using the 64 bit Office.  Primarily because it has the compatibility issues with 32 bit ODBC drivers and ActiveX controls.  And unless you REALLY need 64 bit Excel to be able to handle stuff that 32-bit Excel  won't, then why suffer?
ACCDE and MDE's have to be made bitwise on the target they are intended for.
Those definitely aren't going to be a single distributable.

My latest 6 Dell units have O2013 OEM Click-to-run.
That blew in 32 bit Office on Win 7-64 by default.