Hello All
I'm sure that this problem will come up again and again. After the euphoria of using Access 2007 runtime and being delighted by its simplicity to deploy, I was brought swiftly back to earth over the problems with macros.
Before converting to the runtime extention, I made sure that macros were enabled in the Trust section. This works fine when 2007 is installed, the dreaded security error box does not appear.
However when deployed in a non-Office (Access) environment the dreaded security box appears. What I fail to understand is that when writing the code for Access, the programmers failed to let Access identify macros written in a previous version of Access. How can they be a security risk?
To get to the point, I have spent all day trying to find an "expert" out there who can solve the problem "How do I prevent the security box from appearing"? I know only a simple OK can let the user proceed, but to have to ask a non-computer literate person to understand why it's there is simply not on.
So please HELP!!!
Terence
London
19 August 2010