Ms Access read Registry JETSHOWPLAN

How can I set the Registry value for JETSHOWPLAN "ON" or "OFF" from visual basic in Ms Access 2003.
Who is Participating?
tbsgadiConnect With a Mentor Commented:
Use SetRegValue from the Related Solution
With parameters


Good luck

DbOnTrackAuthor Commented:
Thank you!
I managed to get this working ok to turn Showplan ON and OFF. (syntax important :-))
But now I cannot find the Showplan.out file  - even when I search the C:\ drive - ??

  Call SetRegValue("[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Debug]", "JETSHOWPLAN", "ON")
  Call SetRegValue("[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\Debug]", "JETSHOWPLAN", "ON")
  debug.print "Showplan 3.5 " GetRegValue("[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\Debug]", "JETSHOWPLAN")
  debug.print "Showplan 4.0 " GetRegValue("[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Debug]", "JETSHOWPLAN")

Open in new window

DbOnTrackAuthor Commented:
Thank you for your prompt help in this matter.
Regedit shows JETSHOWPLAN is "ON"
Although when I run tests  I cannot find the Showplan.out file?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.