Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5

    Answered: Programatically Uncheck broken references in a different database

    Last week I needed a snippet to programmatically determine if there were broken references in a list of databases .

    Sinndho answered it perfectly - my question now is - can I programmatically uncheck these references when I find them?

    Thank you in advance.
    Dale Houston, TX

  2. Best Answer
    Posted by Sinndho

    "The References collection has a Remove method, then (from the previous EnumReferences procedure):
    Code:
    For Each ref In appAccess.References
        If ref.IsBroken = True Then appAccess.References.Remove ref
     Next ref
    "


  3. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    The References collection has a Remove method, then (from the previous EnumReferences procedure):
    Code:
    For Each ref In appAccess.References
        If ref.IsBroken = True Then appAccess.References.Remove ref
     Next ref
    Have a nice day!

Posting Permissions

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