Delete Records Or Not

[DS]

I have a Temp table that will have about 500 records a day in it. My
question is...
being that these are records that I don't need after the report is printed
should I delete the records after they are printed or wait until the end of
the day, when I can delete and compile. Will the first option cause a lot
of bloating?
Access 2002
Access 2000 File Format
Thanks
DS

 

[Al Campagna]

DS,
500 records is a very small table to Access. Even 4000 would be very handleable.
I would suggest an example of letting 7 days worth build up in the table (you make that
call as to how many days... 1 month? , 2 weeks?), and on the 8th day's entry, run a delete
query against the table with a date criteria of...
<Date()-7
Actually, after the report prints you can run that delete query every time, it's just
that for the first 7 days, no records would meet the criteria. When you hit day 8, the
oldest date records would be deleted.

That would always leave 1 week's worth (Sun to Sun or Tue to Tue, etc.. whatever your
situation) on hand in case of a problem where an old report might have to be rerun.
Just adjust that "concept" to your specific needs.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[DS]

Thanks Al,
I didn't realize that 500 hundred records were small, I like your idea of
every 7 days.
Thanks
DS