Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Location
    Kansas
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Undelete Table? (Access 2000)

    Ok, I got carried away, and thought I was in an alternate access mdb. I deleted some tables and queries; now, I want them back. The mdb is still as large as it was prior to the delete operation. Is there any way to recover the tables or queries?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Undelete Table? (Access 2000)

    Have you compacted the database (either Compact on Close or through the menu)? If so, the answer is no.
    Charlotte

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Undelete Table? (Access 2000)

    At best, you might be able to recover the last table deleted, if you haven't closed the database yet. Basically, I'd say you've lost the data. If it is real important, and if you haven't compacted your database, there are some companies that offer a recovery service that might (real slim chance here) help. I think it's fairly expensive. Probably best course of action is to bite the bullet and try to reconstruct yourself.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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