Solved

Calling Webservice from Access 2007

Posted on 2012-03-19
6
417 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MS Access query 16 60
Add Underline to custom Caption on Label 4 35
Batch convert csv to xlsx 10 55
Conditionally trimming using VBA 8 34
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

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