"#Error" Replacing Field Contents

Hello. I have a db that was written (by someone else) in Access97. I converted both the fe and be to Access2000 and it seemed fine. But now about twice a week a record will have all of the data in the fields replaced by #Error. When I compact/repair, the field contents change to boxes. I delete the record and have to re-enter the data as a new record. I contact the user (there are about 10) who was likely editing that record to ask them to re-trace their steps. Often they are unaware that there was a problem, received no error message, were only doing what they'd done a hundred times before (albeit in the 97 version), etc. There doesn't seem to be a pattern and I can't re-create the problem.

I think it may have to do with record locking or user security but I'm not very experienced with Access. Sometimes when I try to compact/repair, it tells me a user is still in, even though that user has closed Access and logged off. So I assume that the damaged record still thinks it's in use by that person.

I am about at the point of re-writing the db from scratch but worry that 1) it may be beyond my skill level and 2) that the problem will still be there. Any suggestions would be much appreciated. Thanks.