Auditing

[tonijel]

Hi,
I have DAP database through which users manipulate with data.
There is about 15 different IP's accessing that database and they are all in local network, Intranet.

Someone modified one row with wrong data and I would like to find out which computer made that change.
How can I find out which one of those 15 IP's did modify that specific row?
Is there some log or trace file, some option that I need to enable?

 

[ghudson]

Search for the Environ() function. No clue if this Audit Trail will work in a DAP.

 

[KeithG]

I was going to suggest using Environ() function also. You wont get the IP address but you can retrieve the computer name and user logged into Windows.

 

[tonijel]

thx guys, I read those posts about how to create audit trail of record changes in form. I think it want apply on DAP.

If I could somehow, by using Environ(), get any info on who modified some row,can you tell me how and where will I use Environ() function?

 

[TTime]

Just a thought. Have you tried to apply formatting to the fields to reduce the tye of information that can be entered e.g. only allow up to 999 as opposed to 1000? HTH Bernard