Access 2013 : catch "database or project contains a missing or broken reference" (ActiveX)

Posted on 2014-08-29
Last Modified: 2014-12-10
I have an Access 2000 mdb that uses a third party ActiveX control. It works fine except, when opened on a PC with Access 2013, an error appears when opening the mdb : "...database or project contains a missing or broken reference...".

Is there a way to catch that error and stop the error from appearing when the mdb opens?
The mdb checks for the ActiveX control on the rare occasions when it is about to be used, so I'd like to turn the 2013 error off.

Question by:machine_run
    LVL 84

    Accepted Solution

    Not really ... it's up to you and the end user to insure the environment is properly configured to use the application.

    The mdb checks for the ActiveX control on the rare occasions when it is about to be used, so I'd like to turn the 2013 error off.
    If you can use the database without the ActiveX control, then just remove the control and the reference.
    LVL 10

    Expert Comment

    This error shouldn't be dependent on the Access version. A better solution would be to avoid having the error. What ActiveX control is it expecting? Is it not available in Access 2013?

    When a dependency like a library reference is missing, the code won't compile so you can't catch it from your code.
    LVL 1

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now