Query Access Stats

[Guest]

Is there any way for me to now what queries in my Access database are being
used? I have a db with hundreds of queries and I want to see which ones are
used, how often, and even by whom if possible. What is possible?

 

[Douglas J. Steele]

Take a look at FMS's Total Access Analyzer
http://www.fmsinc.com/products/analyzer/index.html

 

[Guest]

That particular software will only run on code. I dont have any code on this
db just a bunch of linked tables and tons of queries. I am just trying to
extract as much information as I can from it so I can have the company stop
using it. One of the things that would be useful would be access stats.
Anyway, the point is that I dont think that software product can help me.
Any other ideas?

 

[Douglas J. Steele]

Total Access Analyzer doesn't "only run on code". It'll give you details of
what queries are used where.

 

[Douglas J. Steele]

Sorry: On rereading your original request, it sounds as though you want to
know how often the queries are actually being run. Total Access Analyzer
will tell you which queries are used in what forms, reports, etc., but it
won't be able to tell you whether they're actually being run.

Since Access doesn't keep any statistics like that, there's no way that
there could be a 3rd party product to do this analysis. You'd need to build
some sort of tracking into your application and, to be honest, I don't think
you could actually track whether a particular query was being used: only if
a particular form or report was.

 

[Guest]

Yeah that makes sense. I just didnt know if Access could keep any stats.
Is there anyway I can get any info out of the queries? I cant even find a
way to print all their names out. Any info I can get from them all would be
useful. We need to stop using this access database and I am trying to figure
out how to even go about understanding what it has. I think it is mostly
junk that can be replaced by something else. Any other ideas?

 

[Douglas J. Steele]

Have you looked at the built-in Database Documenter?

 

[Guest]

I have been trying. But because of the database having so many queries and
many of them being bad it stops with an error message every two seconds. I
finally was able to get a 5000 page report but when I tried to export it
crashed and closed the application so I am trying again. I wish there was a
way to run it with a silence mode where it didnt give me all the errors so it
could get done sometime today.
Any other tips?

 

[Guest]

I wouldnt mind if it kept track of the errors also... maybe it does... I
guess I will find out in a few hours when this gets done