gbnorton
asked on
When and who accessed an Access table
This sounds remote, but we want to know who and when one of our Access tables was accessed. Could be a linked table. We have many tables in many databases that we don't know are used. We'd like to clean them up(remove).
My brute force idea is to rename the table and see who complains.
Any other ideas?
My brute force idea is to rename the table and see who complains.
Any other ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As mentioned above, Total Access Analyzer will analyze the database and provide you with a broad range of reports.
another useful tool is Rick Fishers "Find & Replace". It will find all instances of a particular value or string in the objects (not the data) in your project, so you can easily identify everywhere a particular table is used. It will also create cross-references. This could help you identify where those tables you are interested in are used, and flag where you need to put the code I mentioned above.
another useful tool is Rick Fishers "Find & Replace". It will find all instances of a particular value or string in the objects (not the data) in your project, so you can easily identify everywhere a particular table is used. It will also create cross-references. This could help you identify where those tables you are interested in are used, and flag where you need to put the code I mentioned above.
+1 on Rick Fisher's utility; it's $37 bucks and well worth the price.
The cross reference will tell you exactly where an object is used, or give you a list of all objects that are not used.
When I inherit a database, I do two or three passes using the cross reference to clean up all the junk.
Jim.
The cross reference will tell you exactly where an object is used, or give you a list of all objects that are not used.
When I inherit a database, I do two or three passes using the cross reference to clean up all the junk.
Jim.
ASKER
I have Ricks Find and Replace. I'll use it as you've suggested.
http://technet.microsoft.com/en-us/library/cc771070.aspx