Access 2010 x64 Development

[DavidT via AccessMonster.com]

Will an application developed using 64 bit Access run on a machine running
the 32 bit version? Anyone have any recommendations?

 

[Arvin Meyer [MVP]]

No.

At present, Microsoft has been recommending that people who do development
in VBA stick with 32 bit Office. There is a 64 bit version of VBA, but it is
a new version, and has the possibility of problematic bugs. Until everything
is running smoothly, I intend to take Microsoft's advice.

 

[DavidT via AccessMonster.com]

OK. So I develop with 32, but I have users that may be running 64 bit. Will
there be issues? I mean other than the documented Long data type (LongPtr),
Declare statements (PtrSafe), ActiveX controls, API calls, and conditional
compilation
<http://msdn.microsoft.com/en-us/library/ee691831(office.14).aspx>

and the undocumented Len function (LenB),
<http://gpgonaccess.blogspot.com/2010/03/work-in-progress-and-64-bit-vba.html
From what I understand, as long as I account for these in my code, I should
be alright.

I will test it out and verify, in the interest of time, though, I'm looking
for known issues.

thanks,