From: Tom at lilabner_99_2000@yahoo.com
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 when I tried a little experiment by creating a simple table and deleting one of its rows, the row simply disappeared as one would expect, without every field being replaced by the word "Deleted". Any idea why Access behaves one way under the simple circumstances I created and this other way in our database? I would be grateful for any information I could get on this. Thank you very much.
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 when I tried a little experiment by creating a simple table and deleting one of its rows, the row simply disappeared as one would expect, without every field being replaced by the word "Deleted". Any idea why Access behaves one way under the simple circumstances I created and this other way in our database? I would be grateful for any information I could get on this. Thank you very much.