Access 2000 run time error "record is deleted"

  • Thread starter Thread starter Becky
  • Start date Start date
B

Becky

I have a database that has multiple users. The form's
data source is a table, and there is an autonumber field
in the table. The form has a "calculate button", which
calculates many values, and I had also coded it to
refresh so that the data is saved at that time. Users
are getting a runtime error which tells them that
the "record is deleted". It does not happen
consistently, but seems to be happening more frequently
lately. I thought that maybe the refresh action was
causing the problem, but when I took that out of the
code, they still got the runtime error. Any ideas???
What can I do to prevent this from happening?
 
If you are sure that your code is not deleting anything, you might have a
corruption problem.
I actually just ran into something similar a couple of days ago.
Is your database split into front end / back end?
Each user have their own copy of the front end?
Try compact/repair both front end and back end.
 
Back
Top