Art
I can't test this right now. My Acc 2010 PC is in the shop. Being in the IT department has the advantage that I can have more than one PC. The disadvantage is anything other than my primary machine is made of parts from old PCs.
You can edit the .reg files to use the key John suggested. If it doesn't work you can always delete the Debug folder in the reg keys.
Right-click the .reg file and select Edit. That will open it in NotePad.
Bill
--- In MS_Access_Professionals@yahoogroups.com, Art Lorenzini <dbalorenzini@...> wrote:
>
> This key does not exist:
> Â
> HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\Office\14.0\Access Connectivity Engine\Engines\Debug
>
> I only have:
> Common
> MSOExamples
> Outlook
> Registration
> User Settings
>
> Under HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\Office\14.0
>
> With warm regards,
>
> Arthur Lorenzini
> Sioux Falls, South Dakota
>
>
>
>
>
>
> ________________________________
> From: John Viescas <john@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Wednesday, February 22, 2012 12:11 PM
> Subject: RE: [MS_AccessPros] Re: Profiler for Access
>
>
>
> Â
>
> Probably not. That writes a new key to:
>
> HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\JET\4.0\Engines\Debug
>
> JETSHOWPLAN text value = "ON"
>
> You could try adding that key to:
>
> HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\Office\14.0\Access Connectivity Engine\Engines\Debug
>
> .. for Access 2010. For 2007, it would be in Office\12.0
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Waco, TX)
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Art Lorenzini
> Sent: Wednesday, February 22, 2012 11:30 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Re: Profiler for Access
>
> There is no text file being generated. Does it work with 2010?
>
> With warm regards,
>
> Arthur Lorenzini
> Sioux Falls, South Dakota
>
> ________________________________
> From: John Viescas <john@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Wednesday, February 22, 2012 11:24 AM
> Subject: RE: [MS_AccessPros] Re: Profiler for Access
>
>
> Art-
>
> It generates a text file in the folder where you have the database.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Waco, TX)
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Art Lorenzini
> Sent: Wednesday, February 22, 2012 10:50 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Re: Profiler for Access
>
> I installed it and double clicked on the ON and it looked like its turned on but it is not doing anything. Does it have to be in the folder where the DB resides?
>
> With warm regards,
>
> Arthur Lorenzini
> Sioux Falls, South Dakota
>
> ________________________________
> From: Bill Mosca <wrmosca@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Wednesday, February 22, 2012 9:25 AM
> Subject: [MS_AccessPros] Re: Profiler for Access
>
> Art
>
> Kinda, sorta. There is a logger that you can turn on/off thay will give you a trace. We have the .reg file in our files folder. It's called ShowPlanRegFiles.zip.
>
> Be sure to turn it off when you don't need it as it can be a big drag on performance just like the profiler is in SQLS.
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile/Bill.Mosca
>
> --- In MS_Access_Professionals@yahoogroups.com, "Art" <dbalorenzini@> wrote:
> >
> > I know there is a profiler for SQL Server which captures TSQL commands being issued to a database. Is there something like that for Access 2010?
> >
> > Thanks,
> >
> > Art Lorenzini
> > Sioux Falls, SD
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Yahoo! Groups Links
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar