?
Solved

Audit Trail, Data Accesss Macros

Posted on 2014-02-22
6
Medium Priority
?
1,235 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 58

Accepted Solution

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

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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
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.

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

Jim.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses
Course of the Month14 days, 23 hours left to enroll

840 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