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

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!!!!!!
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
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).

Martins_ViennaAuthor Commented:
Thannk you! That input helped a lot!
Martins_ViennaAuthor Commented:
Great input - thank you!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.