Results 1 to 4 of 4
  1. 11-29-2011, 10:00 AM #1
    ksmith
    ksmith is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2010
    Location
    South Mississippi
    Posts
    59

    Where Used?


    Just wondering... Does anyone know of a way the get all of the reports and forms where a query is used? In affect a 'Where Used' utility.

    KSmith
    Reply With Quote Reply With Quote
  2. 11-29-2011, 10:31 AM #2
    Robeen
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Not sure if this will help - but it might get you started:
    http://www.fmsinc.com/free/newtips/a...ccesstip21.asp

    I Googled ms access dependencies.

    All the best!
    Reply With Quote Reply With Quote
  3. 11-29-2011, 11:51 AM #3
    ksmith
    ksmith is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2010
    Location
    South Mississippi
    Posts
    59
    Thanks that's what I'm looking for, I think..!

    KSmith
    Reply With Quote Reply With Quote
  4. 11-29-2011, 12:01 PM #4
    Robeen
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Lol . . .

    I just looked at the dependencies for a couple of tables and queries in one of my databases.

    Very useful.

    If I ever want to go in there and clean up unused queries or tables . . . looking at the object dependencies would give me a good starting point to see if the object is used by another object downstream . . .

    All the best!!
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums