Occasionally the users in our database will try to open and edit the same record (admin might be editing the record, ask the user to open their record and then the problem occors)
I get ########### errors on some fields, it locks everybody out, I have to do a compact and repair.
I get the message first like in the link
http://support.microsoft.com/kb/304181
I'd like to know how to avoid this, how to handle this, how to get away from database corruption etc.
advice?