Is there a compiler option in ms-access (2003) that requires all vba code to compile before allowing any code to run? I would like to be able to disable it. I tried to uncheck the boxes with the "Require variable declaration" and "Automatic syntax checking" options, but there was no result.
Background Information
I have just been provided with the ms-access database, which works fine on their machine, but will not work on my machine. I get this error message on startup:
"The expression On Open you entered as the event property setting produced the following error: Method or data member not found"
This is caused by vba compilation errors in what looks like redundant code. Interestingly, the code does not compile on any machine, but on their machine its database can be used on my machine, it is not! I suppose this is something as simple as a compiler option, except that I cannot find it!
(Before anyone mentions this, I know that the real solution to the problem is fixing / removing bad code)
David source
share