Um... can you please explain what you mean by "auto-perging"? (By the way, in English at least, it's more likely to be "purging" than "perging".
Killer42 my frnd !
I solved the problem on the front-end by VB 2005.I'm pasting the code sample here:
[PHP]Private Sub autoParge(ByVal oledbConn As OleDbConnection)
strSQL = " DELETE * FROM INSPECTION WHERE INT(Datediff('d',DATE,now()))>30 "
sqlCommand = New OleDbCommand(strSQL, oledbConn)
Try
oledbConn.Open()
sqlCommand.ExecuteNonQuery()
Catch ex As Exception
MsgBox(ex.Message)
Finally
oledbConn.Close()
End Try
End Sub[/PHP]
Here, INSPECTION is a table of data,DATE is the time inserted in one column of the table (related to the data appearance in the table) and this module has to be called from where it should be.