Hi, I am using dreamweaver 8 to create a web front end for an sql database. I am using ASP files. I have many update/add/delete pages and I need to record every change in a log. Does anyone have any idea how this could be done? My audit table only needs a few columns... ubintAuditID, dtDate, strDetails. strDetails will be a large field in which all the info about the update/add/delete will be stored. I'll give you an example. I have a status table (tblWTDStatus) which has the fields ubintWTDStatusID, ubintMatterWorkTypeID, dtDate, strActioned, strStatus, strComments. If someone changed an entry, say, who actioned the status, from Joe Blogs to Mr T, I would want my audit table to create a record with ubintAuditID = next value, dtDate = date of change, strDetails = tblWTDStatus strActioned FROM Joe Blogs TO Mr T.

If anyone can help me I would appreciate it greatly

Mark