====== MS Access VBA Checklist ======

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

===== MUST =====

  * [ ] ''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)

===== SHOULD =====

  * [ ] 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

===== NICE =====

  * [ ] 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 [[start|Stack Checklists]] | [[..:start|Review Checklists]]

~~DISCUSSION:off~~