[Phpwm] Accessing an MS Access DB remotely.

[Dave Holmes]

I think I will diplomatically refrain from this conversation!

Sorry couldn't resist.... 

<programmers_hat>

but I think it has all been said in the previous emails access is a poor
choice for any application office based or other and has never worked well
on the Internet.

You could write a web service which exposes it but I would recommend getting
the web service to drop the requests in a queue and then a processor
application to process then in a serial manner to avoid any multi-user
issues. 

If this is an order processing system i.e. business critical then you can't
risk the very real potential for data corruption & loss.
 
</programmers_hat>


<entrepreneurs_hat>

Surely there is an opportunity here for you to sell the a holistic web /
intranet based system which fully meets their strategic requirements?

Or are they the type of client that wants to world for 50p and a bag of pork
scratchings!

</entrepreneurs_hat>



-----Original Message-----
From: phpwm-bounces at mailman.lug.org.uk
[mailto:phpwm-bounces at mailman.lug.org.uk] On Behalf Of Chris Allen
Sent: 16 October 2006 10:19
To: phpwm at mailman.lug.org.uk
Subject: [Phpwm] Accessing an MS Access DB remotely.

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


_______________________________________________
Phpwm mailing list
Phpwm at mailman.lug.org.uk
https://mailman.lug.org.uk/mailman/listinfo/phpwm