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
Solved

Calling Webservice from Access 2007

Posted on 2012-03-19
6
415 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
  • 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

856 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