Auto Archive to new BE file

[aeiou137]

Is there visual basic code which could auto archive table data following the below factors:
When whole file size reaches a certain limit. Set Threshold.


When a command button is pressed with correct password entered.
At certain time periods, ie date entered is greater than 3 years old.

Thanks any help is greatly appreciated.

[Mclaren]

geeze...this would be nice to have....

[NTC]

since no db can grow to infinity - archiving needs to occur at some point. or just deletes if there is no need to keep the info.

it is a manual process - generally the dba triggers a series of queries that shave off the oldest records into a separate set of tables that go into an archive db. this is often just an annual event.

Hope it helps.

[aeiou137]

I realize that this may traditionally be a manual operation.
But if you in the opening / closing of the program were to check several parameters you could somewhat automate the process.

IE.

Like the Compact on close routine.

Thus

On application close
check table .... date and if greater than 3 years archive.
Check table ... move from archive less than 1 year to greater than 1 less than 2 years..
If check box xxxx is true then .... archive.