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
pdvsaProject financeAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
When you open a table in design view, you'll see at the top in the ribbon where you can define macro's to run on certain record operations.  Here's a screen shot:

Screen shot, table macros
With these you can write a record to an audit table, say for the before or after update events.

Jim.
0
 
pdvsaProject financeAuthor Commented:
oh that seems simple enough.  i suspect an Append query would be developed on one of the buttons.  

How do you get the buttons to show like yours?  

thank you

ribbon
0
 
pdvsaProject financeAuthor Commented:
Would this work in a split table structure where a BE is on the network?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<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.
0
 
pdvsaProject financeAuthor Commented:
I actually reverted back to AJB's method.  The data macros seemed to be too complicated for me.   thank you
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.