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

[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

 

[Wolfgang Kais]

Hello Paul.

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...

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

 

[Graham R Seach]

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

 

[Paul G via AccessMonster.com]

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.

[quoted text clipped - 18 lines]

tkx, Paul