Source Code

[Michael C]

I've written some code into access to find unused queries and tables. This
checks the RecordSource of forms and reports and checks to see if other
queries access it also. But The query could still be used in source code, is
there a way to programatically search the source code in access?

Thanks,
Michael

 

[Arvin Meyer [MVP]]

You can use the Find Method on a module:

object.Find(target, startline, startcolumn, endline, endcolumn[, wholeword,
matchcase, patternsearch])

See the help files for more info.

 

[Tom van Stiphout]

On Thu, 14 Feb 2008 11:52:34 +1100, "Michael C" <[email protected]>
wrote:

Not to burst your bubble, but there are a few low-cost search
utilities already on the market. "Speed Ferret" and Rick Fisher's
"Find and Replace" are two of them.

-Tom.

 

[Michael C]

Not to burst your bubble, but there are a few low-cost search
utilities already on the market. "Speed Ferret" and Rick Fisher's
"Find and Replace" are two of them.

This is not bursting my bubble, I'm quite happy to not write this. I'm not
actually wanting to specifically search code, I want to find any unused
queries in the database, or in the case that they are used I want to find
where they are used. I want to do the same for tables. I need to do some
housecleaning on a project I have inherited.

Michael

 

[Tom van Stiphout]

Check out the tools at fmsinc.com. I believe their Analyzer tool can
do just that.

-Tom.

 

[John W. Vinson]

I'm quite happy to not write this.

You needn't:

Free: http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com

In increasing order of price and features. I use Speed Ferret quite often.

 

[Ownor]

Not to burst your bubble, but there are a few low-cost search
utilities already on the market. "Speed Ferret" and Rick Fisher's
"Find and Replace" are two of them.

-Tom.

 

[Arvin Meyer [MVP]]

I use Speed Ferret quite often.

I do also and have since Access 2.0. I find it invaluable for finding (and
if necessary, replacing) anything. The FMS tool, although more expensive,
may be better for analyzing usage.