Error when Accessing a COM+ WCF Addin consuming a Webservice from MS Access 2007

Posted on 2011-05-12
Last Modified: 2012-05-11
I am trying to access a Com+ Add-IN within MS Access 2007. In the Com+ Addin a external Webservice is referenced.

I can see all the published objects and methods from VBA - but when I trigger the Method which accesses the external Web Service I am receiving the error message:

"Could not find default endpoint element that references contract ‘stripped out’
in the ServiceModel
client configuration section.  
This might be because no configuration file was found for your application
or because no endpoint element matching this contract could be found in the
client element."

I have investigated a lot of time in this problem - what I have found out is that I have to
modify the applications app.config file and that I have to include the service endpoint references there...
It´s clear to me for a visual studio applicaton - but I have no glue how to handle this issue within MSAccess...

I have also tried to compile the app.config file directly into the DLL - but the result is the same

Please Help!!!!!!
Question by:Martins_Vienna
    LVL 84

    Accepted Solution

    Access can't really consume web services, unless you can do so through SOAP, and even then it's a hair-pulling exercise. You're better off writing a small applet in .NET that can use that web service, then providing the output to Access through some other methods (text files, writing to the database, etc etc).


    Author Comment

    Thannk you! That input helped a lot!

    Author Closing Comment

    Great input - thank you!

    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

    Join & Write a Comment

    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…
    It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    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…

    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