Missing dll error in VBA programing

Posted on 2009-02-24
Last Modified: 2013-12-05
In my ADP application I don't get the results when I click on some buttons .This will happen when I am using Acess 2007  with OS XP ,2008  or 2003 . Same will happen for Access 2003 with OS XP.But it will work fine with OS 2003 and Access 2003 .
Also When I open my ADP application I am getting the messages like your database or project contains a missing or broken reference to the file FPDTC.DLL version 1.0.
your database or project contains a missing or broken reference to the file PLUGIN.OCX version 1.0. It is happening in all the cases except for OS 2003 and Access 2003 .
Please suggest a solution for this
thanks in advance
Question by:logicslab
    LVL 46

    Expert Comment

    Hi logicslab,

    In the VBA IDE
    Go to Tools references & look for the missing Dlls
    If they're not needed then untick
    If needed then browse to where they are installed

    Good Luck!


    Author Comment

    I have searched the dlls in the machine and I put PLUGIN.OCX  in the sytem 32 (it was not there ). and now im getting the error message for FPDTC.DLL  only. But still my application is not working when I click on some buttons . The page is not redirecting .
    I have a form datamanager .there i have a button 'Insurance Companies' and I have options for displaying alll , By selecting teh option button All. After this I need to redirect to the form Insurance Companies ,Instead of redirecting it is skipping from there .
    Please sugest a solution..
    thank you
    LVL 46

    Expert Comment

    is FPDTC.DLL  installed?
    LVL 84

    Accepted Solution

    You must have ALL REFERENCES AVAILABLE in order for your Access app to function correctly. Missing or invalid references can cause troubles throughout your app, not just in the areas where your app uses those references. As Gary said, you must insure that ALL references are available.

    Here's some info on Plugin.ocx:

    FPDTC.dll are the FrontPage Design Time Controls ... do you seriously need those in your application?

    FWIW, I'd do this in the development machine:

    Untick the references (perhaps one at a time) and run a Debug - Compile. If your code compiles without error, then you don't need that reference so you can untick it and redeploy.

    Author Comment

    I have checked for the missing DLLs and I could find only PLUGIN.OCX in my system and it was not in system 32. I put that in system 32.But for the other two(FPDTC.DLL,msdxm.ocx) ,I dont know what to do . If it is a must to run my application properly , from where I can get thses references?. And how can I install thses missing libraries?
    The application is working fine when I am using MSAccess 2003 in OS 2003 .Because all thses libraries are present in this environment .
    Please suggest a solution..
    thanks in advance
    LVL 84
    Sorry to drop this one, but if you need further assistance, or if it appears a question has been abandoned, you can post a "ping" question, something like "Any ideas?", which will alert the Experts that the question is still open.

    Regarding those libraries - in order to use the FPDTC.dll, the user would require the correct version of FrontPage on their machine. As I mentioned earlier, I'd be very surprised if you actually need those dll's and, if you do, then only way to get them is to require your user to have FrontPage.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    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…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    734 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

    20 Experts available now in Live!

    Get 1:1 Help Now