Can an Access 2003 app run in Access 2010 64 bit

[djoosten]

I have an app the was written in Access 2003 and is used by customers using various versions of Access and various OS versions. Recently, one customer installed a new PC with Office 2010 64 bit and the Access application does not run on it. Everything I have found seems to suggest that the code needs to be changed to run on the 64 bit version, but if I change the code to run on the 64 bit version will it still run on the other environments. I have not had any problems with running it on a 64 bit OS like Vista or Win 7 as long as the Access version is 32 bit. Is it possible to write VBA code that works for both 32 bit and 64 bit Access? There are several API functions and ActiveX controls in the app. It appears that these need to be modified but how do I do that without breaking the app for the majority of users?

[Stingaway]

Had this issue with a Pervasive database that I connect to frequently. Took it all the way to Microsoft who said "Yeah, that's a non-starter" (trying to access a 32bit odbc driver with the 64bit version of Access.

I actually have two versions of Access installed for that very reason... everytime I start the 32 bit version, it rebuilds the environment. Same thing when I go back to 64.

Fun stuff.

[djoosten]

We ended up just telling our customers that we will not support the 64 bit version of Access for now since it offers no significant value to the user over the 32 bit version.