I just compiled an update for Access 2007 runtime application i wrote and I'm user's are receiving "Your database or project contains missing or broken reference to the file 'RACtrl.dll' error

Posted on 2008-11-14
Last Modified: 2013-11-29
I just compiled a new installer for my Access 2007 runtime application.  When user's go to open the database they receive "Your database or project contains a missing or broken reference to the file 'RACtrl' version 1.0"  

If I open the application in Access 2007 it runs fine.....
Question by:Niples
    LVL 1

    Accepted Solution

    Additional details about the error:

    The application you are attempting to use has a reference that it cannot resolve to an object, type library, DLL, or external database.  Either the object, type library, DLL, or database was deleted or renamed. Examine the Available references list in the References dialog box in the Visual Basic Editor ( Tools menu) to determine if any action is required. If you did not create this application, contact the programmer or administrator of the system.

    If the reference listed in the Available references list is preceded with "MISSING:" clear the check box to remove the reference if it is no longer required. If you still need to use the reference, clear the check box entry for "MISSING: <referencename>" in the Available references list, and then create a new reference to the file using the Browse... button. If this is an installed database application, you may need to reinstall or repair the application.

    LVL 84

    Assisted Solution

    by:Scott McDaniel (Microsoft Access MVP - EE MVE )
    Does your database have a reference to this file? If so, then you'll need to deploy this control along with your database, and have users install/register it. You can use an installer to do this, and it'll be registered properly.

    Also: This is apparently an ActiveX control for the LogMeIn remote service ... why would you need a reference to this in an Access database?

    If your database does NOT use this control, then you should remove the reference.
    LVL 1

    Author Comment

    There was a reference there that shouldnt have been.  Thanks for your help

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    732 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

    19 Experts available now in Live!

    Get 1:1 Help Now