While doing a select query on a large database table I share with 2 others in an Access 2000 environment, I got a "Record is Deleted" message, and the query stopped. I searched the table and found a record at a specific location with the word "deleted" in every field. It looks like attempting to query past this record caused the msg to be displayed and the query to "crash". What is strange is that the location of this "deleted" record was the former location of a good record that had been updated earlier, as shown by looking at the backup of the table from the day before the problem occurred. This good record appeared to have moved from this location, leaving this "deleted" record in its place. Would anyone reading this have any explanation about why Access behaves in this way? Does updating a record cause it to be moved from one location in the file to another, leaving open the possibility of an imperfect move possibly caused by a power spike, for example? I would be grateful for any information I could get on this. Thank you very much.