Hi one and all, we have a database with over 150 reports which can be run by any one of our users. I have built into the database a form where the users can select various criteria for their reports and at this point I can log the number of times each report is opened. Other users are able to open and run reports and in addition other reports get run as part of an automatic process. An untold number of reports have been allowed to be made and many are now either duplicated or redundant. What I would like to achieve is a log table that is able to log the date and time every report gets run, probably by whom. This is to monitor which reports are not run at all, in order to reduce the size of the database and general housekeeping. I could put something in the 'on current' event but this would mean that I'd have to do this for each and every report we have. The solution I'd like, if there is one is one that can log which object is being accessed what its name is and who is accessing it.
Any help as always would be greatly appreciated