473,320 Members | 1,876 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Webservice help needed please

I've just been informed that an Access 2003 based system in use at one
of my customers now needs to send data in the form of an XML file to a
webservice. They told me it was simple - but I don't know anything
about it and a googling session yesterday made it look very
complicated.

So can anyone help with this question - I don't need anything fancy
and I haven't got the experience to work it all out for myself from
first principles (even though I know I should), I just want to send a
file occasionally. Is there a simple way to do this and if so can
anyone give me a link to follow?

Thanks
Dave
Feb 27 '08 #1
4 1634
"Dave G @ K2" <Da*************@gmail.comwrote in message
news:8e**********************************@x30g2000 hsd.googlegroups.com...
I've just been informed that an Access 2003 based system in use at one
of my customers now needs to send data in the form of an XML file to a
webservice. They told me it was simple - but I don't know anything
about it and a googling session yesterday made it look very
complicated.

So can anyone help with this question - I don't need anything fancy
and I haven't got the experience to work it all out for myself from
first principles (even though I know I should), I just want to send a
file occasionally. Is there a simple way to do this and if so can
anyone give me a link to follow?

Thanks
Dave
1. Create a query to return the data formatted and sorted as required.
2. With the query selected in the db window, click File->Export...
3. In the Save As dialog, drop down the 'files of type' combo and select
XML.
4. In the dialog that pops up, select which files to generate.
5. Click OK.

Done.
Feb 27 '08 #2
Sorry - I should have made it much clearer. My client runs a large and
complex Access 2003 database on a LAN which I have written and
maintain and support. They also have a large and complex website which
I have absolutely no involvement with - it's not my thing

I regularly need to automatically send data of various types, files,
photos etc to the web server whenever certain events are triggered. I
do this a lot right now and the method I have used is to create an XML
file, or whatever is needed, and attach it to an email which is sent
to the web server where it is duly dealt with using perl and php I'm
told. I have found it to be very reliable since emails never fail to
get to the other end.

Unfortunately they now they have a new web programmer and he reckons
that's an old fashioned way to do things and insists that we should be
using webservices to send data from the Access database to their web
server for a new project we're working on.

So it's not the creation of the file that is the problem. It's the
fact that I don't know the first thing about webservices and how to
send the data, and I need to do this fairly quickly, and this is where
I'm seeking guidance

Thanks
Dave

Feb 27 '08 #3
"Dave G @ K2" <Da*************@gmail.comwrote in news:b28f44ac-c6ba-
4c********************@n58g2000hsf.googlegroups.co m:
Sorry - I should have made it much clearer. My client runs a large and
complex Access 2003 database on a LAN which I have written and
maintain and support. They also have a large and complex website which
I have absolutely no involvement with - it's not my thing

I regularly need to automatically send data of various types, files,
photos etc to the web server whenever certain events are triggered. I
do this a lot right now and the method I have used is to create an XML
file, or whatever is needed, and attach it to an email which is sent
to the web server where it is duly dealt with using perl and php I'm
told. I have found it to be very reliable since emails never fail to
get to the other end.

Unfortunately they now they have a new web programmer and he reckons
that's an old fashioned way to do things and insists that we should be
using webservices to send data from the Access database to their web
server for a new project we're working on.

So it's not the creation of the file that is the problem. It's the
fact that I don't know the first thing about webservices and how to
send the data, and I need to do this fairly quickly, and this is where
I'm seeking guidance

Thanks
Dave
On a recent holiday I played bridge with a couple who said they played
"five card majors". I asked them to describe what they meant by "five
card majors".
Later one of the couple made a disparaging remark about my not knowing
what "five card majors" meant. Actually, I did know what "five card
majors" meant to me but I wanted to be sure what it meant to them.

Regardless, I would find a believable reason for asking the new web
programmer to describe more fully what he meant by "using webservices to
send data from the Access database to their web server.”
If he/she answered you could tell us and there might be more than one
person here who is actually doing that and could and would help.
Feb 27 '08 #4
Yhe web services add-in for access can be downloed here:

http://msdn2.microsoft.com/en-us/office/bb400914.aspx

You can most certainly use web services with access 2003.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Feb 27 '08 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
by: Jose Fernandez | last post by:
Hello. I'm building a web service and I get this error. NEWS.News.CoverNews(string)': not all code paths return a value This is the WebMethod public SqlDataReader CoverNews(string Sport)...
6
by: jhooper71 | last post by:
It's been recommended to me to use a webservice and XML for the data manipulation layer for web applications in .NET 1.1. I was thinking I could use the web service to extend the database...
1
by: jens Jensen | last post by:
Hello , i'm calling a webservice generated with oracle webservice java tools. I'm not able to add a web reference to a .net client the usual way with visual studio 2005. I was therefore...
0
by: batista | last post by:
Hello all, I am using a webpage having a grid and im calling a webservice method(using webservice.htc) which after 5 seconds updates the content of the grid, uptil now everything is working...
0
by: ultradiv | last post by:
I have a VB.NET application partly built that produces an xml output (just a file at present) I have a .NET webserver and SQLserver 2000 I need to be able to send the xml to the webserver/database...
5
by: Jonathan Kay | last post by:
Hi, I'd like to my WCF webservice to work both on SSL and without. Unfortunately searching has led to dead ends, references to changes that only work on the old previous beta versions and I...
1
by: =?Utf-8?B?d2R1ZGVr?= | last post by:
I have a web service hosting a WCF library, which works fine but produced a strange signature when interacting with vs 2005/2.0 clients. My method takes 3 strings and returns a bool as below. ...
7
by: eschneider | last post by:
I have a webservice which every time I build it keeps adding Crystal references into the web.config? <add assembly="CrystalDecisions.Shared, Version=10.2.3600.0, Culture=neutral,...
10
by: Anton | last post by:
Hi, when accessing a secured 3rd party webservice i'm getting a 401 HTTP Statuscode (unauthorized). When entering the url in a browser and entering the username and password manually, the wsdl is...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.