Option Explicit vs. Compare Database Statement
Posted on 2002-05-19
I used the Access Performance Analyzer on my application and the only suggestion it offerred was to use an "Option Explicit Statemant" at the beginning of the declaration section of the code behind my forms and reports, in order to make my code run faster
All of the code behind my forms currently begins with
"Option Compare Database" statement.
In order to follow the advise of the analyzer should I insert the "Option Explicit" statement after the "Option Compare Database" statement OR should I replace the "Option Compare Database" statement with the "Option Explicit" statement?
All of the variables in my modules are explicitly defined.
Any comments would be much appreciated. (Ie any negative side effets, implications to using the Option Explicit Satement etc...)