Did the user have any forms open in the background with uncommitted edits?
Were other users modifying the data at the same time?
If neither of those applies, the message can indicate a corruption. Here's
how to solve that.
1. The first step is to ensure you have the JET service pack so this problem
does not keep recurring. Locate the file msjet40.dll (typically in
\windows\system32). Right-click and choose Properties. Click the Version
tab. You should see:
4.0.8xxx.0
If the minor version number does not start with an 8, go to
support.microsoft.com, the Downloads section and get SP8 for JET 4.
2. Once you have verified JET 4 SP8, 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"
3. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://members.iinet.net.au/~allenbrowne/bug-03.html
4. Compact the database:
Tools | Database Utilities | Compact
If the problem is still there get Access to rebuild the database by
following the steps for the first symptom in:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html