Record is deleted

[ejiro]

Attempting to run a query from a database the query build fails and I get the message "Record is deleted". I traced back the data and that there was a record deleted from a record. How do I solve the problem so that I can run queries from the table that a record was deleted without the error message?

 

[ZmrAbdulla]

What type of wuery you are running? Delete query? You need to confirm it in the design view of the query.
also to check
TOOLS > OPTIONS > EDIT/FIND > CONFIRM > ACTION QUERIES


________________________________________
Zameer Abdulla
Visit Me
There is only one perfect child in this world. Every mother has it.

 

[ejiro]

It is a select query

 

[ZmrAbdulla]

Can you post the SQL of the query so that some one can help you.

________________________________________
Zameer Abdulla
Visit Me
There is only one perfect child in this world. Every mother has it.

 

[PHV]

Have all the underlaying tables a Primary Key access is aware of ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ejiro]

All the underlying table have primary keys. I have run this same query format many times without incident. This problem occured only after another user deleted a record.