By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,700 Members | 1,434 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,700 IT Pros & Developers. It's quick & easy.

Access/Jet Statistics

P: n/a
Could you please help me with some reasearch? I have a client that is
using MS Access 2000 and hitting it through the Jet Engine version 4.0
with SP8. Does anyone know of a utility we can use to collect/track
information on Access/Jet activity. I'd settle for just about any
information about what's going on inside Access. :)

Thanks,

Terry

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Feb 09 2005, 03:58 pm, as*************@yahoo.com wrote in
news:11**********************@l41g2000cwc.googlegr oups.com:
Could you please help me with some reasearch? I have a client that is
using MS Access 2000 and hitting it through the Jet Engine version 4.0
with SP8. Does anyone know of a utility we can use to collect/track
information on Access/Jet activity. I'd settle for just about any
information about what's going on inside Access. :)


It is not very clear what you are looking for, but search Google/MS site
for the SHOWPLAN registry setting. That will give you some of what's going
on inside Access, for sure.

--
remove a 9 to reply by email
Nov 13 '05 #2

P: n/a
Hey!. Nice tip and quite helpful!

We would like to see the query plan that Access is using and SHOWPLAN
does provide good information in this regard.

I found a site that explains how this works:

http://builder.com.com/5100-6388-5064388.html

Thanks a bunch.

Terry

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.