Results 1 to 8 of 8
  1. #1
    Join Date
    Nov 2003
    Posts
    5

    Question Unanswered: deleting table and updated query

    I deleted a table and want it back. The problem is that I ran a query, too. I am already using a function similar to the following to recover deleted tables when nothing has happened after you delete it: http://support.microsoft.com/?kbid=209874. My question is, since I ran this query, is there anyway to still recover the table somewhere in the code?

    Sincerely,
    Shannon

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: deleting table and updated query

    Originally posted by smacdonald
    I deleted a table and want it back. The problem is that I ran a query, too. I am already using a function similar to the following to recover deleted tables when nothing has happened after you delete it: http://support.microsoft.com/?kbid=209874. My question is, since I ran this query, is there anyway to still recover the table somewhere in the code?

    Sincerely,
    Shannon
    Well yes if you have not closed or compacted the db since the deletion ... See: http://support.microsoft.com/default...74&Product=acc

  3. #3
    Join Date
    Nov 2003
    Posts
    5

    same link

    that's the same link that i had listed

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: same link

    Originally posted by smacdonald
    that's the same link that i had listed
    Only problem is that your link doesn't work ...

    Question: Did you try this? Did it work?

  5. #5
    Join Date
    Nov 2003
    Posts
    5
    My bad. It doesn't work. But, it is a link to the same page. The problem is that I ran a query.

  6. #6
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Originally posted by smacdonald
    My bad. It doesn't work. But, it is a link to the same page. The problem is that I ran a query.
    That ok ... You didn't answer my question ... Did you try to retrieve the table? Did it work?

  7. #7
    Join Date
    Nov 2003
    Posts
    5
    no, it didn't work.

  8. #8
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Originally posted by smacdonald
    no, it didn't work.
    Ok ... Well you're outta luck then. Running that query probably overwrote the table memory then ...

    How about a backup???? Can you restore or import it from a backup copy?

Posting Permissions

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