I want to add some thoughts due to things I have seen (in person at my jobs) of people doing that are totally outside the bounds of what VBA and Access (or even Excel) expect, and can cause ALL kinds of corruption issues.
- Failure to follow this simple sequence, ALL the time:
- Do some development/design work
- Debug > Compile
- Save
- Use the application
- Failure to follow this simple sequence all the time:
- You're in break mode - do not edit any code!
- Get out of break mode (by pressing Stop, or passing an Exit)
- Proceed.
Not following those sequences can just bring the VBA project into a state of total chaos IMHO.
I've seen people who are over a year into VBA development/learning and they are still trying to do things like editing code in break mode or fully deploying and utilizing totally uncompiled applications. In my experience, doing either of those is asking for trouble. The latter there may be some special circumstances that may warrant, but I haven't come across them yet.