Inhaltsverzeichnis
MS Access VBA Checklist
Version: 2.1
Scope: Access/VBA code, references, packaging, and robust runtime behavior (MDE/ACCDE target).
MUST
- [ ]
Option Explicitis 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