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