Print SQL Tool???

[cheuschober]

Hi.

So, I'm in a bit of a pickle. Unfortunately, one of our higher ups decided to change the definition of a pretty major idea we've been working on. All of about 500 queries now written (and many chained) have information based at some point on the changed concept and now I get the joy of going through and editing all our existant queries and hoping I don't muck anything up.

What I'd like to know is if anyone is aware of a tool / download that could retrieve and/or print the sql of multiple or all queries? It could likely save me a good 3 day's worth of flipping between windows and/or individually printing if such a tool existed.

Any ideas? Any Help?

Thanks,
~Chad

 

[FoFa]

Database documentor does on my 2002 access version.
Tool/Analyze/Database Documentor

 

[cheuschober]

Thanks FoFa -

I wasn't aware that such a tool existed. However, every time I attempt to alter the options to exclude the unwanted information I receive the following error:

'Application-defined or Object-defined error'

Anyone know what could cause this?

Thanks,
~Chad

Addendum: There are no objects open other than the actual database and I've booted everyone else off so that I am the sole user. I still get this message, however, whenever I hit 'okay' in options regardless of whether I have made a change or even selected a query at all.