Remove MS Access Missing References though VBA
Posted on 2004-10-07
Is there a way to remove broken references in an Access application through VBA?
An MDB has a reference to Outlook 2003 lib (msoutl.olb).
When run in an MSOffice 2000 environment this reference is broken ("MISSNG:...") because the path to msoutl.olb is different in Office9 (2000).
Is there a way to either:
1. Update the FullPath of the missing reference (.FullPath is read-only)
2. Remove the missing reference and insert a new one (.Remove method of References collection fails with Run-time error -2147319779 (Object library not registered) )
Please note that I want to do this from VBA or a VB.exe using the Access.Application object, NOT through user interaction via the references window.
PS. To reproduce the behaviour, place a reference to Microsoft Office 11.0 Object Library in an mdb, rename msoutl.olb found in C:\Program Files\Microsoft Office\OFFICE11\MSOUTL.OLB (Replace OFFICE11 with your Office version) and run the MDB. The reference should appear as missing and the code (any code using for example Left$,Right$) will break..
Thanks in advance for your time