UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Audit Trail Questions, Any Version    
 
   
topdesk123
post Oct 25 2014, 01:46 AM
Post#1



Posts: 39
Joined: 31-December 11



Hello,
With regards to this demo: Do I need to define every control on every form?
Thank you.
Gina
Go to the top of the page
 
argeedblu
post Oct 25 2014, 05:55 AM
Post#2


UA Forum + Wiki Administrator
Posts: 14,051
Joined: 26-September 02
From: Sudbury, Ontario, Canada


Gina,
I am not sure what you mean by 'define every control...' but if you are asking if you have to include every control in the audit trail, I would say the answer is no. I think these lines in the tutorial,
QUOTE
.FormControl Me.Lastname 'me.lastname, me.firstname are controls you want to monitor data changes
'From.
.FormControl Me.FirstName
.FormControl Me.Salary
.FormControl Me.LeaveAmount
.FormControl Me.IsMarried

indicate that you just include the controls that you want to audit.
Glenn
Go to the top of the page
 
topdesk123
post Oct 25 2014, 08:52 AM
Post#3



Posts: 39
Joined: 31-December 11



Hello again,
I have about 30 forms/subforms that need auditing, so doing: .
.FormControl fieldname
.FormControl fieldname
.FormControl fieldname
.FormControl fieldname
for all of them would be extremely time consuming.
Thank you for your reply!
Gina
Go to the top of the page
 
FrankRuperto
post Oct 25 2014, 12:32 PM
Post#4



Posts: 93
Joined: 21-September 14
From: Tampa Bay, Florida


I create history tables for certain data I wish to track changes, example customer's change of address, etc.
Attached File(s)
Attached File  History.PNG ( 51.63K )Number of downloads: 16
 
Go to the top of the page
 
argeedblu
post Oct 25 2014, 12:45 PM
Post#5


UA Forum + Wiki Administrator
Posts: 14,051
Joined: 26-September 02
From: Sudbury, Ontario, Canada


>>>for all of them would be extremely time consuming.<<<
Gina,
That is true if you need the audit trail for all controls on all forms. As is usually the case, this sort of thing is easier to implement when you first design forms than when you have existing forms that you need to 'retrofit.' You might be able to speed the process by working with a collection of controls and looping through the collection. I'm not familiar enough with this particular example to suggest exactly how to implement that approach.
Glenn
Go to the top of the page
 
topdesk123
post Oct 25 2014, 08:29 PM
Post#6



Posts: 39
Joined: 31-December 11



Hey Glenn,
I probably don't need to audit every control - however it's a medical database - which requires strict auditing, I currently use a function that I found on this forum which was working fine, but now throws an error that I have been unable to trap. I'm going to see what I can do to minimize the fields audited. Thank you and have a great night.
Gina
Go to the top of the page
 
ScottGem
post Oct 26 2014, 07:43 AM
Post#7


UtterAccess VIP / UA Clown
Posts: 32,177
Joined: 21-January 04
From: LI, NY


Gina,
ANY Audit Trail database that I have seen operates on ALL fields, or selected ones.
If you need very strict audit trails, you might want to look at my blog which uses a data macro to catch changes. If you do your audits on the table level you don't have to do it on a control in each form.
Go to the top of the page
 
FrankRuperto
post Oct 26 2014, 09:16 AM
Post#8



Posts: 93
Joined: 21-September 14
From: Tampa Bay, Florida


If your application needs auditing, it also needs better user permissions security, controlled by the database backend, so I suggest you consider upsizing to SQL Server. It's much simpler to implement db-wide auditing, user permissions at the table and field levels, transaction loging, etc.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    18th November 2017 - 02:42 PM