Performance tracer for Access 2000

[boxertt]

Is there a tool that will analyse or show a trace of VB logic in Access 2000?

I have run the inbuilt performance analyser, but I am not convinced that it watches the code during execution. It seems to me that it simply looks at static elements such as the form content and the underlying queries and tables, without commenting on the form's actual execution and the logic flow through the VB code.

Regards, Wrecktangles.

 

[MichaelRed]

I have used a technique to 'trace' execution through vb, but it does not exactly profile the execution.

Generate a UDT (in a Public module) which includes the relevant info (Module Name, time ...). In the same module, create a few procedures. One would be to clear the trace info. The other would be to use the UDT (passed as an arg) and create a new record in the trace table.

In my implementation, I was also interested in various variables at different points of execution, so it included a process to pass variable names and values to the logging processor, as well as flags to tell the logging process to include / exclude call info from various specific modules (e.g. a "localized" option for the trace).

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over