Finding out the order in which access performs queries

[Guest]

Hi,

I am currently upsizing an MS Access db to a sql server db as part of a
project to put a system on the net. To understand the logic of the current
program it would be most helpful to identify which queries are run in what
order. For example, on a search button, what queries are run. And then when a
figure is calculated, what queries are used. I can view the VBA and step
through etc but thats not giving me what I need.

I haven't used Access for a while so any help would be appreciated.

Thanks,

Nathan

 

[Guest]

hi,

Have you tried the documenter tool that Access offers?
Accessible through Tools --> Analyze --> Documenter

geebee