accde rollout

[joe789]

Hi Folks,

I am about to roll out a ACCDE to folks that may very well have a different version/update install on their MS Access; and thru the years, I have noticed that every once in a while if a ACCDE has been compiled and the user attempts to use the files on a version that may be not as updated or more updated, the file will open but the VBA code in it won't run properly. What is the very best, most fool proof strategy to attempt to prevent this issue?

Thank you very much,

Joe

 

[gemma-the-husky]

1. develop in the lowest version of access any of your users have.
2. use late binding for interfacing with other MS office products

 

[ypma]

I agree with Gemma- the - husky, your master copy should be the same version as the other users.
The following might be of interest to you.
https://support.microsoft.com/en-us/kb/2640696

which in turn references;
https://support.microsoft.com/en-us/kb/983246

It may be worth trying to download and install the hotfix in the latter link.

Regards Ypma