Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jul 2003
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Recover Deleted Items (Access 2002)

    Can you recover Tables that are deleted; I accidently deleted a table and a query.

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

    Re: Recover Deleted Items (Access 2002)

    I'm afraid not. A recent backup is your best bet, if you have one.

  3. #3
    2 Star Lounger
    Join Date
    Jul 2003
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Recover Deleted Items (Access 2002)

    Thanks..

  4. #4
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Recover Deleted Items (Access 2002)

    Hi MigAnt

    As Hans said a recent backup is a must.

    The following code is very limited and will only work if you delete a table and immediately say wooops to yourself.

    HTHITF

    John


    Option Compare Database
    Option Explicit

    ' ACC: How to Recover a Table Deleted from a Database (Q179161)

    ' The following sample function recovers the last table deleted within a Microsoft Access
    ' database. To create the sample function, follow these steps.

    ' NOTE: These steps assume that you are creating the sample function for future use.
    ' If instead you are adding the code directly to a database in which a table has recently
    ' been deleted, skip step 1, because if you have closed Microsoft Access or the database,
    ' the deleted table is not recoverable.

    ' Open your database in Microsoft Access.

    ' In the Database window, click the Modules tab, and then click New.

    ' Type or paste the following code in the module that you have just created:

    ' NOTE: In the following sample code, an underscore (_) at the end of a line is used as a
    ' line-continuation character indicates that the code continues from one line to the next.
    ' You can type lines that contain this character as one logical line or you can divide the
    ' lines of code and include the line continuation character. For additional information
    ' refer to the Microsoft Access 97 Readme File(Acread80.wri). This file is installed by
    ' default in the C:Program FilesMicrosoft OfficeOffice folder.

    ' To test this function, type the following line in the Debug window, and then press ENTER:
    ' Print undo()

    Function UndoTable()

    Dim db As DAO.Database, strTableName As String
    Dim i As Integer, StrSqlString As String

    Dim intMsgDialog As Integer
    Dim intResponse As Integer
    Dim strTitle As String

    strTitle = "

  5. #5
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Recover Deleted Items (Access 2002)

    AWESOME ! ! !

Posting Permissions

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