Re: Delete By Date



I can't think of any other method than the one you suggested.

Mal wrote:
>
> I would like to write some code that will let me delete records that are 180
> days old from the date that the code is activated. The problem with this is
> that I have many tables in my database that are unrelated with each table
> having a different set of records. All of the tables however have a date in
> it.
> Is my only solution is to make a bunch of delete querries for all of the
> tables and call them by code or is there a better way????
>
> Thank You For Any Help
> Mallory
.



Relevant Pages

  • User defined values
    ... not need to dive into the ShapeSheet to change the user-defined values. ... Thanks a bunch, ... Sean ... Prev by Date: ...
    (microsoft.public.visio.developer)
  • Re: Shame on rugby
    ... and had the time of my life raising a toast with ... > a bunch of Irish party animals. ... Prev by Date: ...
    (rec.sport.rugby.union)
  • Need help on update query in Access
    ... If someone has a clue, ... Thanks a bunch. ... Christine ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: O/T: tiny urls...
    ... he would ask a bunch of cyclists about tiny urls... ... I don't have a problem with off-topic posts.) ... Prev by Date: ...
    (uk.rec.cycling)
  • Re: OT Virus Protection
    ... Worth it for that alone... ... It's found and fixed a bunch of problems. ... Prev by Date: ...
    (rec.motorcycles.dirt)