aricon
Active Member
   

Systems Consulting-See website for products!
Posts: 1283
Gender:
|
We could do this using MS Access as the "reporting" application. Essentially the concept would be to have Access "poll" the DBA tables through ODBC, and bring in that information and apply a date/time stamp to each record automatically. This would enable comparative reports to be run. We could even take it further should you desire, which would be to have the application generate an email if certain types of changes were to happen, or certain severities of changes. Obviously, there is a development cost to doing this though. You would have to decide how valuable this is to your operation.
|