Arguments for making a database compile free of errors

[Pat]

What are some arguments on compile free VBA code?

[HansV]

By "arguments", do you mean tips, suggestions?

[JohnH]

By "arguments", do you mean tips, suggestions?

or do you mean Reasons for compiling the code.

[Pat]

Reasons for compiling the code.

[HansV]

The Visual Basic engine will automatically compile code the first time it's run; this means that a syntax/compile error in a procedure or function that is called only infrequently may not be discovered for a while - perhaps until your customer runs it.
Compiling VBA code does not guarantee that the code will work correctly - there can still be runtime errors and logic errors. But at least it ensures that there are no syntax errors in your code.

[StuartR]

The ONLY time that it makes sense not to compile code is if you have conditional compilation that depends on the version of VBA.

[Pat]

Thanks gents