counting number of times tables is used/accessed

[HSL]

Is there a way to be able to track how many times a table is used / accessed?
Trying to clean out a db with obsolete tables.

 

[Tom van Stiphout]

On Thu, 12 Jun 2008 20:35:00 -0700, HSL

Nothing built-in. You'll have to roll your own. Not a trivial task.
-Tom.

 

[John W. Vinson]

Is there a way to be able to track how many times a table is used / accessed?
Trying to clean out a db with obsolete tables.

No. Tables don't have any programmable "handles".

I'd start with using the Documenter (or a thirdparty tool such as Find and
Replace or Total Access Analyzer, see below) to find the interdependencies;
and then perhaps rename each suspect table by adding _OLD to its name, and see
what breaks and who complains.

 

[Brent Spaulding \(datAdrenaline\)]

Check out the Find & Replace tool at www.rickworld.com
Also ... if you become a member of www.utteraccess.com ... you can D/L my
utility for FREE <Yippee> ... it can be found here:
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=48&Number=661031

I never develop with out my SearchForText utility!!! .... My posted utility
will identify where strings (ie: table names) are used, but will not replace
with another set of characters. I do have a "development" version which
does that, I just have not had a bunch of time to refine the new version,
however, if you wish, I would be glad to get you the development version is
you wish ...