Why not write a script to check the LAST_ACC_DATE and see if it is older then XX days, and if it is, set ACCESS_RECEIVE=0. Get a scheduling program that runs a browser job and set it to run each night..ie:open all records,if DateAdd("d", -30, now) > LAST_ACC_DATE then blah blah..^-- bad ASP example, but its 2:30AM.Internet Network Engineer
Local Internet Services, Inc.
PO Box 160
Ludington, MI 49431
(231)845-9797 ext. 109-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Adil
Sent: Saturday, September 28, 2002 1:31 AM
To: '[EMAIL PROTECTED]'
Subject: [VOPmail Beta] disable receive for expired users
We are using modusmail with the extended database. I want inactive (expired) users whose mailboxes get deleted to stop receiving mail until they login again through POP3. So I need two things, the first is to disable receiving mail by setting the the ACCESS_RECEIVE=0 when the mailbox expires. The second is to enable it when the user logs in. I am able to implement the second part by creating a trigger to set ACCESS_RECEIVE=1 whenever LAST_ACC_DATE is updated and it's working. However I am not able to identify the field to monitor that indicates the mailbox has expired. Is there any such field? Currently I manually run a query every now and then to find users who haven't logged in for long time and set their ACCESS_RECEIVE=1.
Thank you,
Adil
Title: Message
Thanks, this is a good start, may be also some
scheduled ISQL command line?
wish
you a good night :)
Adil
