Wrox Programmer Forums
BOOK: Beginning Access 2003 VBA
This is the forum to discuss the Wrox book Beginning Access 2003 VBA by Denise M. Gosnell; ISBN: 9780764556593
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Access 2003 VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old December 30th, 2004, 02:18 AM
Registered User
Join Date: Dec 2004
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Terra Server Web service problem

Hi, it's me again!

Just working through chapter 7. Trying the consuming of a web service example using Terra Server Web Service and it doesn't work for me. When I try to run the TestWebService routine I get a compile error in the struct_TileId structure on the "Public Scale as String" line.

Error reads:
Compile Error:
Expected: Identifier

and it highlights the word "Scale".

Has anyone else run into this problem or was able to get it to run? Any suggestions how to fix it? I am running Access 2002 sp3, I hope that doesn't make a difference.

Thanks in advance,

Old March 14th, 2005, 09:29 PM
Authorized User
Join Date: Dec 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts

I'm also getting an error when attempting to consume the Terra Server web service. However, I'm not getting the same error as mentioned in the original post. Instead, I'm getting a "Type mismatch" error on this line:

strResult = ts.wsm_ConvertLonLatPtToNearestPlace(objLonLatPt)

I tried defining strResult as Variant, but that didn't fix the problem either.

I have Access 2003 installed with Jet 4.0 SP8. The code I'm running is the downloaded Ch7CodeExamples.mdb code, except that I went through the steps described on pages 205-207 to set a reference to the service. Has anyone been able to get this to work?

Old October 10th, 2005, 11:37 PM
Registered User
Join Date: Oct 2005
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts

I'm getting the same error. At first I thaught it wasn't working because I have XP and a few things haven't work because, but if you folks are having the same problem, maybe it's the service.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Web Service Server Requirements ashokparchuri .NET Web Services 0 January 2nd, 2007 06:26 PM
can not connect to the web-service remote server? okll .NET Web Services 4 May 24th, 2006 06:08 PM
Web Service Vs. Client/Server gabrielboys .NET Web Services 10 January 10th, 2006 06:48 AM
ATL Server Web service keepac .NET Web Services 0 April 15th, 2004 05:30 PM
SQL server 2000 as a web service lachupacabra .NET Web Services 0 November 17th, 2003 04:45 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.