Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-21-2014, 11:10 AM   #1
Rushman21
Newly Registered User
 
Join Date: Nov 2011
Posts: 21
Thanks: 5
Thanked 0 Times in 0 Posts
Rushman21 is on a distinguished road
Appending changed records to Archive Table

I have a single table database for inventory. Every 3 months or so, some records get changed or updated. My manager wants to keep an archive of all of the records that have been changed so we can go back and look at an history of all of the records. So, My thought is to create an "Archive" table, appended all of the current records to it. Then, when changes are made, create an Append Query, or what ever works, to copy just the changed records from the Main to the Archive table. There are only 200 items in the inventory so it is not a large database. Any suggestions would be great.
Thank you

Rushman21 is offline   Reply With Quote
Old 08-21-2014, 11:39 AM   #2
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 9,518
Thanks: 363
Thanked 782 Times in 747 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Appending changed records to Archive Table

You could also "Audit" the changes.

See Here:- http://www.access-programmers.co.uk/...ad.php?t=44231
__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Reply

Tags
append , query , table

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Appending records from another table kev88 Tables 4 01-26-2012 01:06 PM
Appending records to table by entering two values dark11984 Tables 5 03-15-2011 03:45 PM
trouble appending records to a table mwcrepeau Modules & VBA 4 03-03-2009 10:07 AM
appending multiple records to a table yuhong Forms 3 09-12-2005 03:34 AM
Appending changed information joltremari General 1 06-26-2002 12:10 PM




All times are GMT -8. The time now is 01:41 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World