Err 3167- Record is deleted @ MeveNext

Posted on 2011-10-20
Last Modified: 2012-05-12
Hello Experts,

I have the following structure, which I use routinely:

Do While Not rs.EOF

   'other code


i've been reciving lately Err 3167- Record is deleted. on my rs.MoveNext.  What could this be? Can my db be corrupt?
Question by:APD_Toronto
    LVL 75

    Accepted Solution

    I would suggest doing a Compact & Repair now ... to see if that clears it up ...

    LVL 67

    Assisted Solution

    RS.MoveNext should not result in such an error message. Trying to access the data of a (meanwhile) deleted record will bring up that error, but nothing else should.
    LVL 119

    Assisted Solution

    by:Rey Obrero

    in your codes

    Do While Not rs.EOF

       'other code ?? what codes are executed here ? are you deleting records ?


    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    "RS.MoveNext should not result in such an error message."
    I don't think that can be guaranteed ...


    Author Closing Comment

    I copied the table into a new one and that did it.

    thanks all

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now