Does Microsoft Access 2007 crash for anyone on opening small tables? Any Solutions?

Answer 1

There are a few different things that could be causing this.

1. Your tables are linked to a source that is no longer available or has moved locations.
2. One or more of your tables has become corrupted. Try deleting the problematic table and re-importing from a backup.
3. Your database just needs to be compacted and repaired. This is the most likely problem and the easiest way to fix it. Crossing fingers it's this one.