Chris Holmes said:
Does anyone know a way to monitor the
frequency of use for MS Access Ojects.
Is there program code that I can develop
or an Add In that I can buy to monitor the
frequency of an objects use.
No, I don't know of anything that does what you want.
You could develop code to do that for a subset of Access Objects, e.g.,
Forms, Reports, and Procedures... by logging each time that particular
object is Opened/Loaded/Executed. You could, I suppose, even call similar
code from Macros (though I use macros very, very little). But there's no
event you can use to trap the use of a Query or a Table.
To log use of Forms, Reports, and Procedures may not be as big a task as it
might seem... the call to the logging procedure could be programmatically
inserted in each Procedure. Should you pursue this, you probably want to
make it conditional compilation code or dependent on a global variable, so
you can turn it off in production mode and avoid the performance hit.
Larry Linson
Microsoft Access MVP
