Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2017
    Posts
    16
    Provided Answers: 1

    Question Answered: Archive data on delete?

    Hey all,

    I am creating a database in Access which uses joins to identify data which has changed from one list to another and then allows the user to pull up the data and delete them. Is there a way to archive these changes in another table with the date and time associated with the change?

    Thank you!

  2. Best Answer
    Posted by ranman256

    "Make an append query to add the records to the archive table,
    Then run the delete query."


  3. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    603
    Provided Answers: 31
    Make an append query to add the records to the archive table,
    Then run the delete query.

  4. #3
    Join Date
    Jun 2017
    Posts
    16
    Provided Answers: 1
    Quote Originally Posted by ranman256 View Post
    Make an append query to add the records to the archive table,
    Then run the delete query.
    I'm giving this a try and so far its working. Just need to play around with the WHERE part of my query. Thank you!

Tags for this Thread

Posting Permissions

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