If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Tracking Log
Hi, What is the best way to have a tracking log? My understanding you can not have one on a specific record set. Is that correct?? The user would like to the ability to see who changed a record, keyed in transaction or deleted a transaction in a form. thank you in advance!! |
#2
|
|||
|
|||
Tracking Log
On Mon, 17 May 2010 14:19:01 -0700, PJ wrote:
Hi, What is the best way to have a tracking log? My understanding you can not have one on a specific record set. Is that correct?? The user would like to the ability to see who changed a record, keyed in transaction or deleted a transaction in a form. thank you in advance!! Up until Access 2010 Access didn't have table level triggers that would let you do this in all cases; if you can ensure that the user can ONLY use a Form for managing data (not bypassing it and using tables or queries directly) you can run an audit trail, with some VBA code. See http://allenbrowne.com/AppAudit.html -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Tracking Log
On Mon, 17 May 2010 17:41:28 -0600, John W. Vinson
wrote: A2010 "standard" databases don't have triggers either, only sharepoint ("web") databases. And of course SQL Server supports triggers as well. -Tom. Microsoft Access MVP On Mon, 17 May 2010 14:19:01 -0700, PJ wrote: Hi, What is the best way to have a tracking log? My understanding you can not have one on a specific record set. Is that correct?? The user would like to the ability to see who changed a record, keyed in transaction or deleted a transaction in a form. thank you in advance!! Up until Access 2010 Access didn't have table level triggers that would let you do this in all cases; if you can ensure that the user can ONLY use a Form for managing data (not bypassing it and using tables or queries directly) you can run an audit trail, with some VBA code. See http://allenbrowne.com/AppAudit.html |
#4
|
|||
|
|||
Tracking Log
Tom van Stiphout wrote:
A2010 "standard" databases don't have triggers either, only sharepoint ("web") databases. And of course SQL Server supports triggers as well. SQL Server would support the logging functions too I suspect. But that's likely out of the scope of the original posters environment. Tony -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ For a convenient utility to keep your users FEs and other files updated see http://www.autofeupdater.com/ Granite Fleet Manager http://www.granitefleet.com/ |
#5
|
|||
|
|||
Tracking Log
PJ,
There are step-by-step instructions for creating an audit trail in the "Access Cookbook." I succeeded in using them with Access 2003 but don't know if the technique works with A2007 and A2010. HTH David "PJ" wrote: Hi, What is the best way to have a tracking log? My understanding you can not have one on a specific record set. Is that correct?? The user would like to the ability to see who changed a record, keyed in transaction or deleted a transaction in a form. thank you in advance!! |
Thread Tools | |
Display Modes | |
|
|