Access 2010 Runtime, AutoExec Macro/Function call problem
Posted on 2013-12-30
I just developed an app in Access 2010, first time in 2010 but I've used prior versions of Access and prior versions of Sagekey for many, many years.
I tested everything on the app and created an installer using Sagekey 2010. I then used the created installer to install the app on my local machines. No issues whatsoever. As designed the app install Access runtime 2010 as part of the install.
Possibly worth noting that even though the runtime 2010 was installed, all of the machines in the office have full versions of Access 2010 on them also.
Moved the app to my client site. The only version of Access on those machines is Access 2003.
The application installed just as expected but cancelled in the Autoexec macro with 'function name cannot be found'. The very first command in the Autoexec runs a function 'fRefreshlinks' to refresh the linked tables in the application. If the tables aren't where the current links are pointing to, it reads the information on an .ini file that tells where the data files are on this installation.
Never even executes 'fRefreshlinks', it cancel on the call to the function.
Does the runtime version of Access 2010 have limitations related to an Autoexec or maybe running functions?
I have used this exact same startup method for many years in Access 2003 without issue.
Any ideas what the issue is?