pdvsa
asked on
Audit Trail, Data Accesss Macros
Experts,
I have an audit trail in my db now but it stopped working. I went to AJB's website as I followed the procedure to implement and it states 2010 is better at creating an audit trail through the use of Data Accesss Macros (sorta like "triggers" as AJB states)
I use 2010 and I am interested in knowing how to implement an audit trail in 2010 using the Data Accesss Macros. It seems as though the trigger method is similar to AJB's procedure.
website:
http://allenbrowne.com/appaudit.html
Thank you
I have an audit trail in my db now but it stopped working. I went to AJB's website as I followed the procedure to implement and it states 2010 is better at creating an audit trail through the use of Data Accesss Macros (sorta like "triggers" as AJB states)
I use 2010 and I am interested in knowing how to implement an audit trail in 2010 using the Data Accesss Macros. It seems as though the trigger method is similar to AJB's procedure.
website:
http://allenbrowne.com/appaudit.html
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Would this work in a split table structure where a BE is on the network?
<<oh that seems simple enough. i suspect an Append query would be developed on one of the buttons. >>
If only it were that simple. You actions in a data macro are quite restricted and running a query is not an option. You have to use the CreateRecord action and set each of the individual fields.
<<How do you get the buttons to show like yours? >>
Change the view to datasheet view.
Jim.
If only it were that simple. You actions in a data macro are quite restricted and running a query is not an option. You have to use the CreateRecord action and set each of the individual fields.
<<How do you get the buttons to show like yours? >>
Change the view to datasheet view.
Jim.
ASKER
I actually reverted back to AJB's method. The data macros seemed to be too complicated for me. thank you
<<I actually reverted back to AJB's method. The data macros seemed to be too complicated for me. thank you >>
Their not simple to work with that's for sure and the editor, one step at a time? Yuck.
Jim.
Their not simple to work with that's for sure and the editor, one step at a time? Yuck.
Jim.
ASKER
How do you get the buttons to show like yours?
thank you