Solved

Audit Trail, Data Accesss Macros

Posted on 2014-02-22
6
893 Views
Last Modified: 2014-02-23
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
0
Comment
Question by:pdvsa
  • 3
  • 3
6 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 400 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.

Jim.
0
 

Author Comment

by:pdvsa
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

ribbon
0
 

Author Comment

by:pdvsa
ID: 39879739
Would this work in a split table structure where a BE is on the network?
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 57
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.

Jim.
0
 

Author Comment

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

Jim.
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

706 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now