JETSHOWPLAN in Access 2003 (v.11)?? -- no SHOWPLAN.OUT file

  • Thread starter Thread starter Paul G via AccessMonster.com
  • Start date Start date
P

Paul G via AccessMonster.com

I am using Access 2003 (11.5614.5606) on Win2000.

I have set the registry, using Getz-s file for ShowPlanOn.reg
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\JET\4.0\Engines\Debug]
"JETSHOWPLAN"="ON"
And I have logged off and powered off,

But when I logon and get into access again, and try a query, -- -- --
There is NO Showplan.OUT file.
Even when I modify the query, add a column or something, and try the query,
still nada.

Has JETSHOWPLAN been turned off in Access 2003 (v.11)?
Is anybody getting it to work in Access 2003?

(On my other machine, using Access2000(9.0.3821) on an NT box,
it works just fine.)
Its been a frustrating Sunday evening...trying to determine causes of slow
SQL...

tkx, Paul
 
Hello Paul.

Paul G said:
I am using Access 2003 (11.5614.5606) on Win2000.

I have set the registry, using Getz-s file for ShowPlanOn.reg
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\JET\4.0\Engines\Debug]
"JETSHOWPLAN"="ON"
And I have logged off and powered off,

But when I logon and get into access again, and try a query, -- -- --
There is NO Showplan.OUT file.
Even when I modify the query, add a column or something, and try the
query, still nada.

Has JETSHOWPLAN been turned off in Access 2003 (v.11)?
Is anybody getting it to work in Access 2003?

(On my other machine, using Access2000(9.0.3821) on an NT box,
it works just fine.)
Its been a frustrating Sunday evening...trying to determine causes of
slow SQL...
Click to expand...

Have you checked the contents of the "My Documents" folder?
 
Paul,

In Windows XP, showplan.out is created in My Documents. In other versions of
Windows, you'll find it in the current directory (enter ?CurDir in the
Access Immediate window to find out the current directory).

I don't have Ken's book with me right now, so I can't check, but make sure
you've created the following Registry key:
\\HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\Jet\4.0\Engines\Debug

....and added a String data type entry called JETSHOWPLAN (in uppercase), and
set its value to ON.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Thank you Wolfgang and Graham,
Yes, indeed, it is found in MyDocuments.
I'll need to make a RED note in the margin of my Getz,
for Win2000 (and XP), that the file is no longer in CurrentDirectory
but rather in MyDocuments.
Paul,

In Windows XP, showplan.out is created in My Documents. In other versions of
Windows, you'll find it in the current directory (enter ?CurDir in the
Access Immediate window to find out the current directory).

I don't have Ken's book with me right now, so I can't check, but make sure
you've created the following Registry key:
\\HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\Jet\4.0\Engines\Debug

...and added a String data type entry called JETSHOWPLAN (in uppercase), and
set its value to ON.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------
I am using Access 2003 (11.5614.5606) on Win2000.
Click to expand...
[quoted text clipped - 18 lines]
tkx, Paul
Click to expand...
Click to expand...
 
Back
Top