Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2012
    Posts
    13

    Unanswered: Access 2007 Object Dependencies on a Field

    I know that Access 2007 allows you to check which objects are dependent upon a given object so that you can make sure it's okay to delete that object without screwing up other objects.

    I was wondering whether this type of function was available for a given field. In the process of updating my database design, sometimes a field becomes obsolete. In this case, I update all my queries and forms according to the new design without using the obsolete field.

    However, I have over 100 queries in this particular database. I was wondering if Access could give me a list of queries that depend on a given field.

    If this is not possible, that's okay; I'll just correct the errors as they pop up in the future.

    Thanks

  2. #2
    Join Date
    Feb 2012
    Posts
    14
    It's a very imprecise method, but you can try wildcard searches on the Expression field of hidden tables MSysQueries/MSysObjects.

    Code:
    SELECT MSysQueries.Expression, MSysObjects.Name
    FROM MSysQueries INNER JOIN MSysObjects ON MSysQueries.ObjectId = MSysObjects.Id
    WHERE (((MSysQueries.Expression) Like "*blah*"));

  3. #3
    Join Date
    Jan 2012
    Posts
    13
    Quote Originally Posted by amonroejj View Post
    It's a very imprecise method, but you can try wildcard searches on the Expression field of hidden tables MSysQueries/MSysObjects.

    Code:
    SELECT MSysQueries.Expression, MSysObjects.Name
    FROM MSysQueries INNER JOIN MSysObjects ON MSysQueries.ObjectId = MSysObjects.Id
    WHERE (((MSysQueries.Expression) Like "*blah*"));
    That works quite well; thank you very much!

Tags for this 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
  •