Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    289
    Thanks
    0
    Thanked 1 Time in 1 Post

    Obtain query list with dependent tables (2003 sp2)

    I have a large database with about 400 tables of which more than half are archives and temp tables the user refuses to delete. I want to encourage these be moved to a separate database but many of these tables have related queries which I would also like to move. My first step of course would be to distinguish the tables I want to keep from those I would like to move, so I need a list of the tables. I was able to obtain the list with the help of <!post=post 662388, 662388>post 662388<!/post>.

    I know I can view the dependencies one at a time, but I am hoping my friends at Woody's Lounge can show me how to print a table list with dependent queries.
    Thanks
    chuck

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Obtain query list with dependent tables (2003

    Rick Fisher's Find and Replace can be used to generate a report of cross references. It is not free but you can download a trial that works for 30 days.
    Regards
    John



  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Obtain query list with dependent tables (2003

    Note: the cross reference option is only available to users who have paid and registered the add-in; it cannot be used in the free trial version.

    Find and Replace is well worth its modest price - it is a very handy tool.

  4. #4
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    289
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Obtain query list with dependent tables (2003

    I had purchased Rich Fisher's Find and Replace at your suggestion some years back and never knew it had this cross reference feature. It works beautifully. Talk about something being right under your nose.
    Thanks
    chuck

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •