Automatic deletion of records

[Richard]

I have set up a WebSite with user submitted news items and discussion
groups, fed by an Access database.

I need to find a way to automatically delete news items and discussion
items - ie table records - on a regular basis in order to keep the
..mdb size down and news and discussion items recent.

I could of course use a GLOBAL.ASA session start script which compares
table record STAMP dates with the current DATE on say the 15th of each
month, deleting whichever records are older than say 3 months.

However, this would mean that the tables are checked on every session
start for that day of the month. The WebSite will be receiving a large
number of visitors and I don't want the script to have to run 500
times!! Who knows what that would do to the DB integrity!!??

Is there any way I can set the script to run just once a month without
it having to be triggered by a new session??

Thanks for any useful ideas.

[Bob Barrows]

Richard wrote:

> I have set up a WebSite with user submitted news items and discussion
> groups, fed by an Access database.
>
> I need to find a way to automatically delete news items and discussion
> items - ie table records - on a regular basis in order to keep the
> .mdb size down and news and discussion items recent.
>

[url]http://www.aspfaq.com/show.asp?id=2143[/url]

HTH,
Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Mosley Jones III]

"Richard" <richardtinkler@yahoo.com> wrote in message
news:be39f0a3.0311011414.29eeec62@posting.google.c om...

> I have set up a WebSite with user submitted news items and discussion
> groups, fed by an Access database.
>
> I need to find a way to automatically delete news items and discussion
> items - ie table records - on a regular basis in order to keep the
> .mdb size down and news and discussion items recent.
>
> I could of course use a GLOBAL.ASA session start script which compares
> table record STAMP dates with the current DATE on say the 15th of each
> month, deleting whichever records are older than say 3 months.
>
> However, this would mean that the tables are checked on every session
> start for that day of the month. The WebSite will be receiving a large
> number of visitors and I don't want the script to have to run 500
> times!! Who knows what that would do to the DB integrity!!??
>
> Is there any way I can set the script to run just once a month without
> it having to be triggered by a new session??
>
> Thanks for any useful ideas.

what about this

if Application("theLastDate") <> day(date) then
DO SOMTHING
Application("theLastDate") = day(date)
end if


this way it can not be done kmore than once in a day unless you restart the
app.

PS

Application variables last the life of the application (until you reboot the
web server)

Session variables last as long as the users Session

[Jeff Cochran]

On 1 Nov 2003 14:14:17 -0800, [email]richardtinkler@yahoo.com[/email] (Richard)
wrote:

>I have set up a WebSite with user submitted news items and discussion
>groups, fed by an Access database.
>
>I need to find a way to automatically delete news items and discussion
>items - ie table records - on a regular basis in order to keep the
>.mdb size down and news and discussion items recent.
>
>I could of course use a GLOBAL.ASA session start script which compares
>table record STAMP dates with the current DATE on say the 15th of each
>month, deleting whichever records are older than say 3 months.
>
>However, this would mean that the tables are checked on every session
>start for that day of the month. The WebSite will be receiving a large
>number of visitors and I don't want the script to have to run 500
>times!! Who knows what that would do to the DB integrity!!??
>
>Is there any way I can set the script to run just once a month without
>it having to be triggered by a new session??

Run it as a scheduled task, in VBS. Heck, this is Access, you could
create a macro that did what you wanted and schedule that.

Jeff