There is not something that does this automatically, because of the network
of relationships that usually underlies the data structure in Access.
What was the reason you needed to do this? There are some valid reasons to
do this, but unless your tables contain millions of records it may not be
useful.
More information on when and how in article:
Archive: Move records to another table
at:
http://allenbrowne.com/ser-37.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"James W." <wa**@cwgsy.net> wrote in message
news:cb**************************@posting.google.c om...
I was just wondering is there a function in Access 2000 that allowes
it to automatically scan the data to see if, after a set period of
time, it is deleted.
Thanks guys and girls
James W.