Possible to archive tables in Access with Date/Time stamp?

#1 (**permalink**) 11-Nov-2005, 20:08 PM

I import data to Access each day but would like to archive the previous day's
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7127-possible-archive-tables-access-date-time.html
data and the corresponding table with the appropriate date. Is this possible?

If yes, how would this be coded, or better yet, run through a simple macro?

Thanks,

Ed

*

#2 (**permalink**) 11-Nov-2005, 20:08 PM

You can, but typically shouldn't. If you store the date in the record, then
just keep everything in that one table. When you run reports queries or
forms, then you can filter your records by that date. It is rarely a good
idea to create identical tables with a date in the name of the table. How
will you ever go back and run historical or combined reports?

Just store the date with each record.

Now, in some cases, you may want to go back and purge very old data. Maybe
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7127
run a delete query once a year or once a month to delete old records. Of
course, you could make a backup copy before doing the deletes.

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7127

--
Rick B

"Ed" wrote in message
news:075372E0-7D13-4738-9E58-2736DBC98B5A@microsoft.com...
>I import data to Access each day but would like to archive the previous
>day's
> data and the corresponding table with the appropriate date. Is this
> possible?
>
> If yes, how would this be coded, or better yet, run through a simple
> macro?
>
> Thanks,
>
> Ed