As usual, there is a download associated with this article, but this time it is multi-dimensional. It contains a Microsoft Access database that should work for you, out of the box, so long as you have Access 2003 installed. If it...
See more »
As usual, there is a download associated with this article, but this time it is multi-dimensional. It contains a Microsoft Access database that should work for you, out of the box, so long as you have Access 2003 installed. If it fails to work for you, then you will need to find and/or install and register the MSSoap30.dll library. We will talk about that later, but it is the only piece a user needs to consume a Web Service from Microsoft Access. For those who want to get into the guts of this thing, I have included the SQL Script for creating the ErrorLog table and the el_InsertErrorLog stored proc (also shown below) and the Dot Net code I used to create my web service. You can explore my simple service, provided my web server is still up, by following this link ... http://amazecreations.com/ErrorLog/ErrLogFunctions.asmx Before we continue, allow me to give credit where it is due. My web service began with an example posted in an MSDN Advanced Basics article by Ken Getz. He wrote a simple web service to return the requestor's IP address. I thought it was so simple and elegant, I used it in my own testing, until I moved on to my LogNewError() method. You may play with either of them through the web service default page shown above. An entire article could be written about creating the web service, and indeed, many have been, so we will leave the details of that a small mystery for this article and move on to the pertinent part, consuming the web service from Access.
See less »
Kaboodle will send you a newsletter and updates from your friends. You can unsubscribe at any time. Kaboodle does not sell or share your email address or personal information with anyone.
Kaboodle requires all users to provide their real date of birth as both a safety precaution and as a means
of preserving the integrity of the site. You will be able to hide this information from your profile if you wish.
Added by 1 people