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 Stack Checklists | Review Checklists

Zuletzt geändert: on 2026/01/08 at 01:50 AM