16 min read
Fixing Common Problems
A blank form, a slow database over a network, a security warning on open — most everyday Access problems have a short, predictable fix.
Field Notes: The Usual Suspects
Symptom vs. likely fix
| Symptom | Likely fix |
|---|---|
| "The database needs to be repaired or cannot be opened" | Usually minor file corruption after a crash or an interrupted network save — try Compact and Repair on a copy of the file, and restore from your most recent backup if that doesn't fully resolve it. |
| A form or report looks broken or blank | Check that its Record Source property still correctly points to an existing table or query — a renamed or deleted source is the most common cause. |
| "This action or event has been blocked by Disabled Mode" | Access disables VBA code and some queries for security when opening a database from an unfamiliar location. If you trust the source, click Enable Content in the yellow security bar, or add that folder to Trusted Locations. |
| The database runs very slowly, especially over a network | Confirm the database has been properly split, run Compact and Repair periodically, check that queries include appropriate criteria, and confirm the network connection to a shared back-end file is stable. |
| Multiple people can't open the database at once | Check that the database isn't set to open in Exclusive mode by default, and confirm the shared folder's Windows permissions allow every intended user to both read and write to that location. |
More lessons in Microsoft Access · Next: Understanding and Fixing Common Errors · Previous: Access on Mac and Other Platforms