Auto Archive?

  • Thread starter Thread starter Cyp
  • Start date Start date
C

Cyp

hey guys
can i have the archieve of tables take place automatically everyday?

in my case:
i want to have lets say 20 tables to be archieved AUTOMATICALL
everyday in the morning, and their contents in current the database t
be deleted.
how can i do that?

thnx for all your help

This is the code for archieving is here:

http://allenbrowne.com/ser-37.htm
 
I did this I was looking for the code I used to send to you, but I can'
find it.

But I know what was done, after querying out what to be archived the
deleted,

1. I would take that data and create a "make table" then rename tha
"whatever_old" then archive and delete.

2. For All other days use same system above except add a delet
"whatever_old" to the beginning so that it just wipes out old data an
makes new table in old data place.

hope this works for you.

Much Succes
 
in my case:
i want to have lets say 20 tables to be archieved AUTOMATICALLY
everyday in the morning, and their contents in current the database to
be deleted.
how can i do that?
Click to expand...

Are you really generating so much data EVERY DAY that it's necessary
to archive daily!? A database can hold 2 Gigabytes of data - to be
safe, let's say one gigabyte; that's a WHALE of a lot of data!

If you do, I'd suggest having these 20 tables in their own separate
backend database. Have a template database with empty tables; archive
the full .mdb file daily and replace it with the empty one.
 
Back
Top