I'm trying to understand why I'm having such difficulty deploying an Access database to other computers. We have two databases developed in Access 2003 and deployed using the Custom Startup Wizard and the Package Wizard in the 2003 Developers Extensions. Basically, they only run correctly when the Macro Security Level is set to Low.
What's so confusing about all this is that they both have a certificate attached (at first it was just a self-certificate, then later we bought a "real" certificate) and when I ran the "Find Expressions Blocked in Sandbox Mode" within the Custom Startup Wizard, it came back on both files and said there were none. Yet from what I understand of the SandBox Mode, it's behaving exactly as if that's the problem.
What's more, I've been able to actually track down the offending line of code in one of the databases. (It broke when it tried to reference a sub-sub-report) The other database is less obvious. The error is occuring somewhere where one combo box is referencing another combo box and has a before update as well as an after update action. But like I said before, these errors only show up when the Macro Security Level is set to Medium.
The most troubling part of this is that on my computer, where some or most of the work was done on these databases, the database works great regardless of the Macro Security Level! What up with that? It makes me very queesy to think that there could be these types of errors in the databases that we're developing and I would not have any way to detect them on my machine.
I guess my question in all this is
1) what's going on? Why is it that they work fine on my computer and not on anyone else's? Are the expressions being blocked by the sandbox mode and if so, why can't the startup wizard find them?
2) how do I fix it? Is the only solution to perform all the testing on a different computer? How do I know that it will behave correctly on someone else's computer?