Re: Posting Data in an Access Database stored on a web server

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Duncan (ddimech_at_ads.com.mt)
Date: 10/13/04 

Date: Wed, 13 Oct 2004 09:02:43 +0200

Thanks ofr the suggestion.

Brendan, in my case I cannot retrieve the data from the web server and post
it in the local database as the data is not available on the web server
first.

I will give it a try on the web services though

Thanks
Duncan

"Brendan Reynolds" <brenreyn at indigo dot ie> wrote in message
news:u2dFNgEsEHA.3588@tk2msftngp13.phx.gbl...
> I've done it the other way around (retrieve data from the remote server
and
> append it to local tables) and I concur with Val's suggestion elsewhere in
> this thread of using a Web Service. The Web Services Toolkit for Office
2003
> (downloadable from Microsoft's web site) makes it very easy to call web
> services from Access.
>
> --
> Brendan Reynolds (MVP)
> http://brenreyn.blogspot.com
>
> The spammers and script-kiddies have succeeded in making it impossible for
> me to use a real e-mail address in public newsgroups. E-mail replies to
> this post will be deleted without being read. Any e-mail claiming to be
> from brenreyn at indigo dot ie that is not digitally signed by me with a
> GlobalSign digital certificate is a forgery and should be deleted without
> being read. Follow-up questions should in general be posted to the
> newsgroup, but if you have a good reason to send me e-mail, you'll find
> a useable e-mail address at the URL above.
>
>
> "Duncan" <ddimech@ads.com.mt> wrote in message
> news:eBuOqG6rEHA.1816@TK2MSFTNGP15.phx.gbl...
> > Dear All,
> > I have an Access 2003 database residing on a local server. The
frontend,
> > also built with Access 2003, resides on the users machines. A client
> > requires to have another backend on the outsourced web server. This
> > backend
> > will also be in Access 2003 and shall the powering the client web site.
> > Now
> > according to the requirements, a button name 'SEND TO WEB', should be
> > availble on the frontend. When this button is pressed, a link between
the
> > frontend and the backend on the webserver should be made and the data
will
> > be posted to the web site database.
> >
> > If you have any idea how this can performed, please post me at your
> > earliest
> >
> > Thanks and Regards
> > Duncan
> >
> >
>
>

Relevant Pages

  • RE: Problem with MSXML3.dll
    ... for working as a web server for web services ... devload fmtmsg fmtres corestra coresiow coresioa serdev coreloc crt_rtti ... SERVERS_MODULES= mssoap1 wisc10 mssoapr soapisap soapprxy telnetd ftpd asp ...
    (microsoft.public.windowsce.platbuilder)
  • not able to create socket ,coz of insufficient user rights
    ... I am developing a web server in ASP.NET. ... There are 2 web services in it. ... failing, I am not able to debug this code. ... to create socket because of insufficient user rights. ...
    (microsoft.public.security)
  • Not able to create socket , coz of insufficient user rights
    ... I am developing a web server in ASP.NET. ... There are 2 web services in it. ... failing, I am not able to debug this code. ... to create socket because of insufficient user rights. ...
    (microsoft.public.inetserver.iis.security)
  • Encrypted file system / web server usage.
    ... A friend wants to store some documents so that he can retrieve them ... Is there any way data can be stored on a web server such that even if ... He is quite happy to dedicate the task to multiple computers. ...
    (comp.sys.sun.admin)
  • Re: What are the best approaches?
    ... Instead of downloading a COM component, ... component that would "know" how to access the web server using Web Services. ... > data files this COM will use and we have all copy-rights of those binary ...
    (microsoft.public.win32.programmer.ole)