in query it states 'record is deleted' but I have not deleted it .

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Problem with queries in Access - 30 May 2006 11:29 GMT

In Access I have 3 tables linked together, from that I have made reports
through the query. This has been working perfecting for some time now. But
today, I tried to open one of the reports and it stated 'record deleted'. I
went to the query which stated the same. When I have tried to create a new
query it works fine until I use the expressions then it states 'record
deleted' again. Does anyone have any ideas, I've looked though the hwlp
option and can't see anything. Any feedback would be appreciated

Reply to this Message

Allen Browne - 30 May 2006 12:46 GMT

See the 3rd symptom in this article:
Recovering from corruption
at:
http://allenbrowne.com/ser-47.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> In Access I have 3 tables linked together, from that I have made reports
> through the query. This has been working perfecting for some time now.
[quoted text clipped - 5 lines]
> deleted' again. Does anyone have any ideas, I've looked though the hwlp
> option and can't see anything. Any feedback would be appreciated

Reply to this Message