Find All Queries contain a field

[BR]

Hello All,

I inherited a database from a former employee and am trying to locate
any query that contains a particular field name. Is there a way within
access or 3rd party software to show all the queries that contain a specific
field name.

Thanks in advance

 

[John Spencer]

Products to document the database and/or do a global find and replace. All
have Access 97 and later versions. Some don't have an Access 2003 version,
but may still work with Access 2003.

Shareware (Try and Buy):
Find and Replace http://www.rickworld.com

Commercial (Try and Buy)
Speed Ferret http://www.moshannon.com

Total Access Analyzer http://www.fmsinc.com

Free (For Access XP Only??):
http://www3.bc.sympatico.ca/starthere/findandreplace

In Access,

You could write a custom routine that stepped through all the queries and
looked for the specific string and if it existed, print out the name of the
query.

 

[Jamie Collins]

I inherited a database from a former employee and am trying to locate
any query that contains a particular field name. Is there a way within
access or 3rd party software to show all the queries that contain a specific
field name.

Quick and dirty aircode, intended for use in the Immediate Window:

Set rs = CurrentProject.Connection.OpenSchema(adSchemaViews)
rs.Filter = "VIEW_DEFINITION LIKE '%CustomerID%'"
Do While Not rs.EOF : ? rs!TABLE_NAME : rs.MoveNext : Loop

Set rs = CurrentProject.Connection.OpenSchema(adSchemaProcedures)
rs.Filter = "PROCEDURE_DEFINITION LIKE '%CustomerID%'"
Do While Not rs.EOF : ? rs!PROCEDURE_NAME : rs.MoveNext : Loop

Jamie.

--

 

[moshannon]

SPEED Ferret 4.1 can inspect any database in Access 2002/2003 format
provided that a copy of Access 2002 is installed on your system. It can
also inspect databases in Access 2000 format if a copy of Access 2000
or Access 2002 is present on your system. And it can inspect databases
in Access 97 format if a copy of Access 97 is installed.

SPEED Ferret 5.0 is currently under development. It will directly
support Access 2003 and Access 2007, as well as Access 97, 2000, and
2002, and numerous other platforms including SQL Server. In addition to
search and replace functionality, SPEED Ferret 5.0 will also include
project comparison and project documentation capabilities.

Bob Snyder
Black Moshannon Systems