Share via

Query Error Message: Record Deleted

Anonymous
2011-03-10T19:20:15+00:00

Whenever I run a query, I get an error message: Record is deleted. The query then opens and none of the information is in there, but it does not actually delete any of the records I created. Even when I start a brand new query, I get the same message. How doi fix this problem so I can run queries again.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-03-11T14:04:21+00:00

    It doesn't say a number for the records deleted, but I know that none of my records have been deleted by looking at the original table. Here is the SQL statement:  

    SELECT CCA.JOB, CCA.OWNER, CCA.[NO], CCA.ST, CCA.SUB, CCA.CITY, CCA.ZIP, CCA.MH, CCA.[DATE 11], CCA.PA, CCA.DATE6

    FROM CCA

    WHERE (((CCA.LABEL)="3"));

    I have been using the same database for years and haven't ever had a problem with it. Upgraded to the 2007 version in December and has worked fine since then.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2011-03-10T21:19:47+00:00

    Does the message tell you how many records were deleted? It could be that it is telling you 0 records will be deleted. If that is the case your query is probably not set up correctly.

    If I'm right about the 0 recs can you post the SQL for your query? To see the SQL just change from design view to SQL view. Then copy and paste the statement here.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2011-03-10T20:55:46+00:00

    I use the run(!) button

    Was this answer helpful?

    0 comments
  4. Anonymous
    2011-03-10T19:24:21+00:00

    What action are you initiating to run the query - Command Button, Macro, etc.?

    Was this answer helpful?

    0 comments