Last time query/table/report/etc used or accessed? 1

[squirleegirl]

Is it possible to find out the last time a query, table, report, form, etc. was used or accessed?

I know I can use the built-in documenter, but it only tells me when it was created and the last time it was modified.

I need this because I was handed a MS Access application that is running poorly. It is a fairly large application with too many users and basically, it should be running something other than Access, but that is besides the point. To convert these functions to SQL and a different front-end will take a very long time - especially with only myself doing the work.

But, in the meantime, I would like to at least "clean up" the application as I know there are a ton of queries, tables, forms, reports, etc that are not being used. But, if I could know the date the last time each was used, I would be able to clean out alot more.

Does anyone have any suggestions?

Thanks,
Squirleegirl

 

[MichaelRed]

There is no intrinsic function for this. I am not aware of any UDP generically available to collect the information either.

Generally, the size of he apps only effect the (app) load time, not the execution time.

It makes sense to remove the "dead" objects, as it offers a clearer 'picture' of the app, and thus some insight into it's design.

There are numerous threads herein (Tek-Tips) which promote this theme (removal of "dead objects". I suggest the (agressive) use of the search capability with (for starters) KeyWords [Unused | Objects | Document].

Please also (CAREFULLY) read & heed the cautions re keeping backups of all such objects until their death is thoroughly verified.

For a commercial package which advertises the capability to identify "Dead" objects, look at "SpeedFerret". But be aware that it (too) has limitations.





MichaelRed

 

[squirleegirl]

Thanks for the advice. I'll see what I can find.