Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Audit Trail, Data Accesss Macros

Posted on 2014-02-22
Medium Priority
Last Modified: 2014-02-23

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.  


Thank you
Question by:pdvsa
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 58

Accepted Solution

Jim Dettman (Microsoft MVP/ EE MVE) earned 1600 total points
ID: 39879686
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.


Author Comment

ID: 39879720
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


Author Comment

ID: 39879739
Would this work in a split table structure where a BE is on the network?
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

LVL 58
ID: 39879760
<<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.


Author Comment

ID: 39880932
I actually reverted back to AJB's method.  The data macros seemed to be too complicated for me.   thank you
LVL 58
ID: 39881086
<<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.


Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question