Record Auditing

[Dalel23]

I have an interface designed in VB 6 with an Access Database Backend.

I have a couple fields defined in my database

CreatedDate, CreatedByID, LastAuditDate, LastAuditByID, LastRevisionDate, and LastRevisedBy.

User clicks on create button, at that point and capturing the user network logging and setting CreatedDate, LastAuditDate, LastRevisionDate to now

I have a tabbed form with several grids. The Top Grid is the parent. Everything is linked just like access subforms.

I want to know how can make sure that LastAuditDate, LastAuditByID, LastRevisionDate, LastRevisedBy are captured properly?
Any example would be greatly appreciated

Thak you so much

 

[MarkSweetland]

Without the use off a trigger (as in SQL Server) that captures any table changes and allows the developer to perform other actions based on the interaction, you're probably going to have to do it manually. Although I would track the action on the 'Save' button rather than the 'Create' because it would seem there would be no changes made to the underlying data until some action is taken and saved. You could funnel all save action through a single function to log the action and immediately return to the calling module to finish.


Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach