MS Access VBA Checklist

Version: 2.1
Scope: Access/VBA code, references, packaging, and robust runtime behavior (MDE/ACCDE target).

• [ ] Option Explicit is enabled in all modules; no implicit variants
• [ ] Compile is clean (no missing references); references are minimal and documented
• [ ] Error handling is consistent (On Error GoTo … with centralized logging/mapping)
• [ ] No hard-coded paths; use user/app data folders; relative paths where feasible
• [ ] External connections use parameterization (ADO/OleDb); no SQL string concatenation
• [ ] ACCDE/MDE build process is documented and reproducible
• [ ] Security posture is documented (trusted locations, signing, macro settings guidance)

• [ ] Separate UI and data access logic; avoid heavy logic in form events where possible
• [ ] Provide version stamp and „About“ info for supportability
• [ ] If using split DB: locking/concurrency expectations are documented

• [ ] Add self-check routine (references, permissions, connectivity)
• [ ] Provide structured logging export for support cases

Version: 2.1 (Split)
Author: Wolfgang van der Stille

Back to Stack Checklists | Review Checklists