Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Record is Deleted (97)

    I have a database that I created and another department is using. This database has been working fine for at least 2 years. When I run a report or a query behind the report, I am getting the following error: "Record is deleted. You referred to a record that you deleted or that another user in a multiuser environment deleted. Move to another record, and then try the operation again." It looks like all the records are there. When I run the query, it shows the data and then the error "Record is deleted" appears and then the data has #Name? where the data should appear. Any help would be appreciated.

    I am no longer with that department and can't figure out what happened.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Record is Deleted (97)

    Try compacting the database (you need to be the only user to be able to do that). If you have installed Jet 3.5 SP3, compacting will also repair the database.

    If you don't have SP3, you can download it from ACC97: Updated Version of Microsoft Jet 3.5 Available for Download. The update also comes with a standalone compacting utility JetComp.exe. This utility is able to repair some databases that the internal compact command can't handle.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Record is Deleted (97)

    Thank you - thank you. I panicked. I have Jet 3.5 SP3. It seems to be ok now. When I took out the date parameters, the data was ok but when a report or query asked for a date range - the error "Record deleted" would appear. Thanks again.

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Record is Deleted (97)

    I wouldn't make the assumption that all is OK until you've done some serious testing. I would guess that one or more records contains a date that is somehow invalid. Try sorting on each of the date columns and see if you get errors, or you get funny looking values instead of dates at one end or the other of the sorted records. Anytime a query won't run because you put in a date parameter, something is suspicious. Better to <img src=/S/stop.gif border=0 alt=stop width=26 height=24> it now and not be <img src=/S/yikes.gif border=0 alt=yikes width=15 height=15> later!
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •