By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,325 Members | 1,931 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,325 IT Pros & Developers. It's quick & easy.

Disposing of Old data

P: n/a
Hi,

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.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.