Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jun 2004
    Location
    Oxford, Oxfordshire, United Kingdom
    Posts
    203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    add-in installation (XP SR3)

    I've recently installed an add-in called Query Dependency, which tells me what queries are dependent on which tables.

    Two questions:
    a) when I open one of my databases on one of my machines, I'm told either that QD can't access the clipboard, or else: Method '~' of object '~' failed. Nothing I can google seems remotely intelligible on these. Can anyone help?

    [img]/forums/images/smilies/cool.gif[/img] does anyone know of a better add-in or utility that would help me trace dependencies of forms and reports as well as queries.

    many thanks

    Philip

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: add-in installation (XP SR3)

    If you have the chance of upgrading, Access 2003 has the new Object Dependency tool built in.

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

    Re: add-in installation (XP SR3)

    As you have no doubt discovered, development on Query Dependency appears to have stalled - nothing seems to have happened since 2004.

    The add-in "Find and Replace" from Rick Fisher Consulting is very useful - it offers global find and replace, with many options. The registered version (not free, but well worth the money) has a cross-reference tool that will show which database objects are used by others.

  4. #4
    3 Star Lounger
    Join Date
    Jun 2004
    Location
    Oxford, Oxfordshire, United Kingdom
    Posts
    203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: add-in installation (XP SR3)

    many thanks to both.

Posting Permissions

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