• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 30. Maintaining Your Application > Detecting Broken References

Detecting Broken References

Prior to Access 2002, it was difficult to locate and diagnose broken references. Access 2002 and Access 2003 offer BrokenReference, a new property of the Application object that rectifies this problem. If broken references exist, the property evaluates to True. If no broken references exist, it evaluates to False. Querying the BrokenReferences property is much more efficient than looping through each reference to determine whether it is intact. The code looks like this:

Sub DetectBrokenReference()
    'Display whether or not database contains a broken reference
    MsgBox Application.BrokenReference
End Sub


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint