Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Location
    Lund, Sweden
    Posts
    8

    Red face Unanswered: Recover deleted row

    Hi there.

    I wonder if it is possible to recover a number of deleted rows from an access database?

    It's a whole table that has been deleted probably with an SQL-query like "DELETE FROM logg".

  2. #2
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Re: Recover deleted row

    Originally posted by haagen
    Hi there.

    I wonder if it is possible to recover a number of deleted rows from an access database?

    It's a whole table that has been deleted probably with an SQL-query like "DELETE FROM logg".
    I dont know of any way to get that data back, there is no transaction log in access that you can restore from. Sorry
    Jim

  3. #3
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820
    you've only got 2 options
    1 is to import the table from a backup of the database
    2 spend tens of thousands getting a specialised data recovery expert to reindex the data thats been deleted (while praying that when access deleted it didn't promptly over right the those areas of the hard drive)
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

Posting Permissions

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