Table usage in Queries?

[authorsami]

Is there any easy way to find all the queries that a table might be used in?

Thanks
Sharon
sharon@comptutor.net

 

[SgtJarrow]

recently posted within the last month or so, wa s post by LonnieJohnson I believe, with this exact answer....I am searching for it but an not finding it....

****************************
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[authorsami]

I just searched by that name and did not find anything that fit.....

Thanks
Sharon

 

[IConsult2IT]

While this might sound like an ad it is not. I have no connection to this company. I wish they (or someone) had a program to document Access the way Filemaker had but until that time Try this:
SPEED Ferret
Global Find & Replace Utility
for Microsoft Access

SPEED Ferret finds and replaces text strings in all properties of tables, queries, forms, reports, macros, modules, relationships and import/export specs.
Applications

- Locate every place at which an item is referenced.

- Rename tables, queries, fields, forms, reports, controls, macros, and more while propagating name changes throughout the database.
- Customize an application by replacing key business terms with those preferred by a client.
- Upsize an application more quickly by finding and replacing field names that are not permitted by SQL Server.

Features

- Property Cache dramatically speeds searches by minimizing costly object inspections.

- Preview Window lets you review and edit replacements before saving them.
- Automated Backups allow you to undo all changes at a later time.

http://www.moshannon.com.