When To Compile A Database

[Aaron5714]

I am relatively new to VBA programming in Access and am wondering if/when I should be compiling my database (i.e. from the VBA Editor, selecting Debug > Compile Database). Should I be doing this every time I add/edit code, or only before distributing a new version to users, or do I not need to worry about it at all? I haven't been running this command and my database seems to work fine, so I am thinking that Access must be automatically compiling my code anytime I make changes?

Any insight would be appreciated.

[June7]

Should run Compile after any VBA code edits to expose some coding errors. During execution, run-time error msg will popup if code has bugs. Guess you are an excellent programmer if you never see errors.

Do you include Option Explicit line at the top of every code module?

[Aaron5714]

Should run Compile after any VBA code edits to expose some coding errors. During execution, run-time error msg will popup if code has bugs. Guess you are an excellent programmer if you never see errors.

Do you include Option Explicit line at the top of every code module?

Thanks June. Yes I always use Option Explicit. I do sometimes get runtime errors when testing then have to go back and fix the code. I'll try compiling from now on and maybe that will make things a bit easier.

Thanks!
Aaron