UnderSeven
asked on
How to get text of all access queries
I have an access db that is very complicated someone before me wrote. They have several queries, number easily a couple hundred. I'm trying to find a specific keyword within the SQL text of a query, but I don't know which one. Is there a way I can export all queries, or search the contents of them for specific text?
Using access 2010
Using access 2010
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I think I'll use all of these. I'm selecting the database documentor as the best simply because it uses built in functionality. Thanks.
I'll second MX's comment; best (cheap) money you'll spend on a development tool. And besides the find and replace, the cross reference utility in there is a god send when trying to cleanup someone else's DB.
Rick has really never gotten the praise he deserves for that tool...
JimD.