Beginning Access™ 2007 VBA

8.2. Using Data from Web Services

Before you can consume a web service, you must download and install the Microsoft Office 2003 Web Services Toolkit. Further, the toolkit requires that you have at least one product from Microsoft Office 2003 installed on your machine. As of this book's writing Microsoft has not indicated whether a newer 2007 version will be released or not. At the time of this book's writing, the easiest way to obtain the toolkit is to go to www.microsoft.com/downloads/details.aspx?familyid=fa36018a-e1cf-48a3-9b35-169d819ecf18&displaylang=en

Once you get the toolkit installed, the example in this section will work with Access 2007. If you cannot install the Toolkit, move on to the next section.

If you cannot locate the toolkit at the preceding link, you can go to the downloads area of Microsoft.com: www.microsoft.com/downloads. Then, select the Office and Home Application Download Category in the left navigation pane and then run the following search: Select Office System for Product/Technology and type Web Services Toolkit in the Keywords text box. Click the Search button. You will see a link to the Microsoft Office 2003 Web Services Toolkit 2.01 or later.

You can then follow the instructions on the page to download and run the setup program or just launch the setup directly from the Web site. Follow the onscreen instructions to complete the installation.

After you have the Web Services Toolkit installed, you can use web services from your Access applications. ...