What This Book Will Cover
You migrated. It mostly works. But now things are breaking in unexpected ways — queries return wrong results, forms throw errors, reports look different, dates are wrong, and some features just stopped working.
This is the quick-reference troubleshooting guide you keep open on your desk during the first month after migration. Each of the 50 entries follows the same format: symptom, cause, fix. No theory, no background — just the answer.
Planned Contents
- Query issues: wildcard changes, date format errors, NULL handling differences, JOIN syntax problems
- Form issues: #Deleted errors, slow form loading, bookmark errors, combo box failures
- Report issues: formatting changes, missing data, grouping differences
- VBA issues: DAO errors, type mismatch, connection timeouts, transaction handling
- Data issues: truncated text, date shifts, boolean confusion, decimal rounding
- Performance issues: queries that were fast in Access but slow on the server (and why)
- Connection issues: ODBC timeouts, linked table refresh, DSN vs. DSN-less connections
- Each entry: Symptom → Cause → Fix (with code examples)