Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Records deleted by accident (2000, SR1)

    Hi folks,

    I have a client who mistakenly deleted three invoices (and their related data) from their database. The invoice ID's are Autonumbered. I found the deleted invoices in an old backup, but my understanding is that Access will not allow me to reinsert those invoices with their original numbers.

    Is there a workaround for this that isn't more trouble than it's worth?

    Thanks for your help.

    Charlie T.

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

    Re: Records deleted by accident (2000, SR1)

    If you create a query based on the 'backup' table that selects the three invoices, including their AutoNumber value, and change it into an append query that adds the records to the 'production' table, the inserted records will keep their autonumber value.

  3. #3
    Star Lounger
    Join Date
    Apr 2002
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Records deleted by accident (2000, SR1)

    Cool! Thanks -- I'll have to try it out.

    Regards,

    Charlie T.

Posting Permissions

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