Running 64bit Windows 7 & 10 OS, but 32bit OFFICE 365 Pro (which includes MS ACCESS) on both OS's (Win7 & Win10).
We assumed that if you compiled MS ACCESS VBA code on a Windows 10 machine (saved as a .accde file), it would NOT run on a Windows 7 machine; that it would not be backward compatible and run on Windows 7. Having said that, the Windows 10 compiled VBA code in MS ACCESS works just fine on the Windows 7 machines.
Is it the 32bit OFFICE controlling the VBA COMPILER that explains this? And it doesn't really matter about Windows 7 or 10 because they're both the 64bit OS?
We're just hoping for a warm and fuzzy confirmation that it's more than dumb luck that the Windows 10 compiled MS ACCESS VBA code is running just fine on Windows 7.
Thanks.
Maxis