Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 431
  • Last Modified:

Calling Webservice from Access 2007

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
CloudApps
Asked:
CloudApps
  • 3
  • 3
1 Solution
 
Nico BontenbalCommented:
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
 
CloudAppsAuthor Commented:
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
 
Nico BontenbalCommented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
CloudAppsAuthor Commented:
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
 
Nico BontenbalCommented:
And this codes works in 2007/2010 as well, doesn't it?
0
 
CloudAppsAuthor Commented:
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now