This database is being shared on a network. Is it split, i.e. you each have
your own copy of the front end database, with the tables attached from a
shared location? If not, you will need exclusive access to fix it, and
probably should involve your IT people rather than do this yourself.
You unchecked the Name AutoCorrect nonsense, which probably did cause the
problem. Good. Now compact the database:
Tools | Database Utilities | Compact.
Next, decompile a copy of the database by entering something like this at
the command prompt while Access is not running. It is all one line, and
include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
The compact it again.
After that, open a code window, and compile (Debug menu).
Test. If it is still not fixed, follow the 6 steps for the first symptom in:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html