Does anyone know if it is possible to log user actions. I have a database that is continually "creating" corrupt records and I think that a user is doing something very strange, is always seems to be the same person

Yes, you'd have to use an API call to extract the name of the user logged onto that computer on the network. Then attach that user ID to a table with a date and time. Search the knowledge base for something like "user ID" or "network ID".

Other than that, I suggest you send out an e-mail to your office politely re-educating them of proper data input.



Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division