Is there a way to tell where exactly a certain table being used?

I

Irina

I have a lot of queries, reports, modules in a database and I need to rename
a table. Is there a way to get a list of queries, reports and module where
that particular table is being used? So I do not have to check every single
object.
Documenter did not work....
thanks
 
J

Jerry Whittle

Rich Fisher's excellent Find and Replace add-in might be just the ticket. It
can change everything related to the table and change them also.

If you register it (one of the best $37 I've ever spent), the
cross-reference report can find what queries use which reports and forms.
It's a good way to find orphans.

http://www.rickworld.com/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Where is the list of tables? 3
tracking from a query to a table 2
"Where used" Analysis to find all occurrences of fields, tables, e 1
List of where queries are used? 1
Is there a way to retrieve table descriptions? 1
Membership database updates 33
Counting multiple memberships 1
Updating an unlinked table in front end database 5

Top