[Phpwm] Accessing an MS Access DB remotely.

[Chris Allen]

I was wondering if anyone would be able to offer any pointers on this 
matter:

A client has an internal system at his office, that is based on Microsoft 
Access 2002. This is used as a customer database, order processing etc.

He wants an online portal to this database, whereby Engineers with PDA's can 
view outstanding jobs assigned to them, and interact in real time with the 
internal system.

I have done something similar using PDA's with PHP in the past, but it 
involved an onsite webserver and middleware, in order to protect the 
internal database.

This is what I want: The web portal will be hosted elsewhere, and the access 
DB will remain on the customers site. Is there a way of accessing this 
database from the outside world via PHP and performing SQL queries on it? I 
assume it will need some sort of server setting up onsite?

Thanks.


>From: phpwm-request at mailman.lug.org.uk
>Reply-To: phpwm at mailman.lug.org.uk
>To: phpwm at mailman.lug.org.uk
>Subject: Phpwm Digest, Vol 38, Issue 6
>Date: Sat, 14 Oct 2006 12:15:16 +0100
>
>Send Phpwm mailing list submissions to
>	phpwm at mailman.lug.org.uk
>
>To subscribe or unsubscribe via the World Wide Web, visit
>	https://mailman.lug.org.uk/mailman/listinfo/phpwm
>or, via email, send a message with subject or body 'help' to
>	phpwm-request at mailman.lug.org.uk
>
>You can reach the person managing the list at
>	phpwm-owner at mailman.lug.org.uk
>
>When replying, please edit your Subject line so it is more specific
>than "Re: Contents of Phpwm digest..."
>
>
>Today's Topics:
>
>    1. RE: IRC (James Blizzard)
>    2. RE: IRC (James Blizzard)
>
>
>----------------------------------------------------------------------
>
>Message: 1
>Date: Fri, 13 Oct 2006 18:06:37 +0100
>From: "James Blizzard" <jim at acidhl.co.uk>
>Subject: RE: [Phpwm] IRC
>To: <public.darren.beale at siftware.co.uk>,	"'West Midlands PHP User
>	Group'" <phpwm at mailman.lug.org.uk>
>Message-ID: <002301c6eee9$f5e7aef0$0200a8c0 at jim>
>Content-Type: text/plain;	charset="us-ascii"
>
> >> #phpwm
> >> on:irc.freenode.net
>
> >must.resist
>
>
>--
>Darren Beale
>
>Siftware
>1 North Works
>London Lane
>Upton-upon-Severn
>WR8 0HH
>
>t: 01684 59 49 59
>m: 07711 716 197
>
>w: http://siftware.co.uk
>
>--
>No virus found in this outgoing message.
>Checked by AVG Free Edition.
>Version: 7.1.408 / Virus Database: 268.13.3/473 - Release Date:
>12/10/2006
>
>
>
>_______________________________________________
>Phpwm mailing list
>Phpwm at mailman.lug.org.uk
>https://mailman.lug.org.uk/mailman/listinfo/phpwm
>
>
>
>
>
>
>
>------------------------------
>
>Message: 2
>Date: Fri, 13 Oct 2006 18:07:15 +0100
>From: "James Blizzard" <jim at acidhl.co.uk>
>Subject: RE: [Phpwm] IRC
>To: <public.darren.beale at siftware.co.uk>,	"'West Midlands PHP User
>	Group'" <phpwm at mailman.lug.org.uk>
>Message-ID: <002601c6eeea$0c54cd80$0200a8c0 at jim>
>Content-Type: text/plain;	charset="us-ascii"
>
> >> #phpwm
> >> on:irc.freenode.net
>
> >must.resist
>
>I keep trying to get out, but they keep drawing me back in!
>
>
>
>
>
>------------------------------
>
>_______________________________________________
>Phpwm mailing list
>Phpwm at mailman.lug.org.uk
>https://mailman.lug.org.uk/mailman/listinfo/phpwm
>
>
>End of Phpwm Digest, Vol 38, Issue 6
>************************************

_________________________________________________________________
Be the first to hear what's new at MSN - sign up to our free newsletters! 
http://www.msn.co.uk/newsletters