[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Ms Access read Registry JETSHOWPLAN

Posted on 2009-04-23
3
Medium Priority
?
915 Views
Last Modified: 2012-08-14
How can I set the Registry value for JETSHOWPLAN "ON" or "OFF" from visual basic in Ms Access 2003.
0
Comment
Question by:DbOnTrack
  • 2
3 Comments
 
LVL 46

Accepted Solution

by:
tbsgadi earned 750 total points
ID: 24213955
Use SetRegValue from the Related Solution
With parameters
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Debug]

  "JETSHOWPLAN"="ON"

Good luck

Gary
0
 

Author Comment

by:DbOnTrack
ID: 24215576
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 - ??

DbOnTrack
  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

0
 

Author Closing Comment

by:DbOnTrack
ID: 31573713
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?
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question