log who opened what

[Guest]

I have ~20 access database with thousands of macros, modules, forms, queries
all in access 97. I need to upgrade to 2003 and want create a new access
2003 database with only the objects that are being used. Is it possible to
turn on some sort of logging that will log every object opened, by whom and
when.

 

[Rick B]

I did this. I simply added code to the open events of my forms and reports
to log an entry in a table. As I noticed items showing up in the table, I
would remove the code from my item and highlight it on a list. After about
a year I removed any objects that were not highlighted and made sure all the
logging was turned off.

With queries, I changed the name to include an "x" if I thought they were no
longer used. If a user encountered an error, I would change the name back.
After about a year, if I had not been informed of any errors, I deleted the
queries that still had the "x".

Unfortunately, there is not a real good automatic way to do this.

Hope that helps,

Rick B

 

[George Nicholson]

In addition to Rick's answer: FMS has an excellent $ product, Access
Analyzer, that will cross reference objects in your db (queries, forms,
fields, etc.) and then produce reports listing items that are not referenced
anywhere in your database, (including references in code if your code is
written in a way that allows the tool to recognize object references as
such). This is more "what is the program using" than "what are my users
using", but may help speed Rick's 2 year process along.

www.FMSinc.com

HTH,

 

[jwm]

Check http://www.databasecreations.com/prod_apsm.htm