Solved

Calling Webservice from Access 2007

Posted on 2012-03-19
6
421 Views
Last Modified: 2012-08-14
I am using Access 2007. I need to call the following webservice at the following URL. The webservice returns a string value. I have a reference to the Microsoft Office Soap Type Library v3.0. I am using the Visual Basic version of the webservice.
---------------------------------------------------------------------------------------------------
NADSWebserviceVersion.TIMECARD_VERSION_1

https://timecardweb.econz.com/axis/services/timecard1Soap?wsdl
---------------------------------------------------------------------------------------------------

Thanks,
0
Comment
Question by:CloudApps
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 37741173
This webservice has many methods. So you need to know what method you want to call. In Office 2003 you had the http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=2224 but this is no longer available in 2007. If you have a Office 2003 machine somewhere you could use that to create the code to call the webservice and then convert it to 2007.

Here's some information about calling a webservice from Office 2007:
http://msdn.microsoft.com/en-us/library/dd819156(office.12).aspx#xl2007ConsumingWebServices_ExploreIt
0
 

Author Comment

by:CloudApps
ID: 37744055
Nicobo:

I have the Microsoft Office Development Tools installed as part of my Visual Studio 2010.

It does not list Access as an option for building an Add-In. It does show Excel, Outlook, Word...

Going back to Office 2003, does not feel like a good option going forward.

Help!
0
 
LVL 22

Accepted Solution

by:
Nico Bontenbal earned 500 total points
ID: 37744365
You'll only be using 2003 to create the VBA code to call the webservice. No need to port the whole application to 2003.
Another option would be to create a com component in Visual Studio 2010 that calls the webservice, and then call this com object from Access. Or just built this part of your application in Visual Studio an then call this Visual Studio application from your Access database.
0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 

Author Closing Comment

by:CloudApps
ID: 37749681
Nicobo,

I took your advice and used Access 2003 with the Web Service Toolkit to consume the webservice.

It is a great tool.

I guess it is Microsoft that I am upset with for having removed the toolkit from Access 2007.

Thanks again,
0
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 37751334
And this codes works in 2007/2010 as well, doesn't it?
0
 

Author Comment

by:CloudApps
ID: 37752763
Nicobo,

The class modules create by the Web Service Toolkit compiles and runs in Access 2007. I have not tried it in Access 2010.

The database itself is a .mdb

Thanks again,
0

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

729 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