hey helping programmers! i was wondering if anyone knows how to go about doing "Audit Trailing " in vb let me know please...i amusing backend ...access and vb frontend..i am working on my school project and it requires that the user can just hit an audit button and it will display things like
who all were logged on todate
what changes they made if any.
date and time etc.
i believe it requires lots of coding...and i donot have a clue!
thanks in advance and more thanks when you will help me............
Anjolie, things such as the current user logged onto the machine can be found (along with most other things) in the Windows Registry. You can find this entry in the following branch:
HKEY_LOCAL_MACHINE\Network\Logon\username
Dates and Times can be recorded when the program is fired up. So you could create a program that starts with a Sub Main(). Then you won't have any forms that need to be shown. You would run this on startup of the machine by placing the program (of a shortcut to it) in the "C:\WINDOWS\Start Menu\Programs\StartUp" directory or by placing the Path (of the exe) in the following Registry Branch:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run
Note: There are many and varied *spy* programs out there however as you say you require a program that you need to write yourself. So hence I help you with these suggestions.
Diplomacy is being able to tell someone to go to hell in such a way, that they actually look forward to the trip.
Here is some source code from a program that I have written which (kind of) monitors my machine while I am not at it and Removes my "trail" if I'm the one who's logged in.
I have currently got this outputting to a Text File (simple yes, but effective).
The Registry code is not mine so I do not take credit for it. (Although I wouldn't mind being able to)!
The Internet This doesn't work just yet, however if you look up the links (within the commented code) I'm sure you'll find something.
It is at this stage able to delete stuff from the Windows Documents list, and clear the Run History (From the Start:Run Menu)
Diplomacy is being able to tell someone to go to hell in such a way, that they actually look forward to the trip.
Another thing. DON'T COPY MY CODE LINE FOR LINE!!!
Have some originality, get a life, pull out your finger, and change/modify the code so that it suits your purpose. Review the comments, edit them, so they become your own.
Replace Variable Names with your own Variable Names. Change the Names of Objects on the form(s) and within your code.
Goodness, now I am teaching classes on how to get away with Plagiarising somebody else's work.
In other words you are going to school to LEARN. So don't sponge off other peoples work, because in the REAL world, that sort of thing is generally NOT appreciated.
Diplomacy is being able to tell someone to go to hell in such a way, that they actually look forward to the trip.
I recieved your email. Here are my thoughts on it:
You obviously are only looking at creating something quite simple, so in simple words, what exactly are you trying to achieve (in plain english describe exactly the function that you want your program to carry out). Like for instance what exactly is a "sop generator"?
Or if it can't be described in simple words draw a diagram in word or power-point and email that to me, or attach it here.
That way I'll have a much better idea of what you are actually trying to do.
Diplomacy is being able to tell someone to go to hell in such a way, that they actually look forward to the trip.