Error 3167 Record is deleted

[david720]

Error 3167 Record is deleted
And
Sometimes the main entry form displays a record in the form where all
fields are "#Delete"

Why do we get this error sometimes (about 2 times a week)?
It happens from different users and on different workstations.
Also in this application no records are ever deleted and would be
difficult for a user to delete a record

Environment:
Access 2003 (converted from Access 97)
XP workstations, jet 4 with SP 2
Split into Front and Back end, both mdb's
Large databases, FE, 39m, BE, 140m
The main table has a large record length but the system functioned
find in ver 97

Thanks for any responses!

 

[Tony Toews [MVP]]

Error 3167 Record is deleted
And
Sometimes the main entry form displays a record in the form where all
fields are "#Delete"

Why do we get this error sometimes (about 2 times a week)?
It happens from different users and on different workstations.
Also in this application no records are ever deleted and would be
difficult for a user to delete a record

So long as the users haven't figured out an interesting way of
deleting a record this could be a sign of corruption.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

Each user has their own copy of the FE?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/