Can You Locate Fields?

N

Novice2000

Hi,

There are many queries built into our database. I changed one of the fields
from Text to Yes/NO. Is there any way to conduct a search to find out how
many of the queries use that field? Not too hopeful, but I had to ask. Thanks
 
O

Ofer Cohen

Try

SELECT MSysQueries.Expression, MSysObjects.Name
FROM MSysQueries INNER JOIN MSysObjects ON MSysQueries.ObjectId =
MSysObjects.Id
WHERE MSysQueries.Expression Like "*FieldName*"
 
K

KARL DEWEY

Go to menu TOOLS - Analyze - Documenter. Click on Queries, select all, and
click on Options to select your data. Click Ok and again Ok. Click on the
icon that is a 'W' to save the results as a Word document in Rich Text Format
(RTF file extention), then search for the field name.
 
N

Novice2000

Thanks that works great!

Ofer Cohen said:
Try

SELECT MSysQueries.Expression, MSysObjects.Name
FROM MSysQueries INNER JOIN MSysObjects ON MSysQueries.ObjectId =
MSysObjects.Id
WHERE MSysQueries.Expression Like "*FieldName*"
Click to expand...
 
Top