[Phpwm] Accessing an MS Access DB remotely.

[Reuben Pearse]

We have a similar setup with a system that we developed for one of our 
customers.

They use an Access front-end in the office, but the back-end data is in 
SQL Server, but available in Access as attached tables. On the SQL 
Server server we installed the IIS module which allows SQL XML Support 
in IIS. After opening the appropriate access on the customers firewall, 
we could then query (via XML) the customers database from PHP running on 
a hosted webserver. Depending on how PHP has been setup on your 
webserver, you could do the queries using an ODBC connection.

Hope this helps

-- 
Reuben Pearse
Principal Technical Consultant
reuben.pearse at pslconnect.com
T +44 121 428 4440   F +44 121 428 3454
PSL  The Old Sewing Factory  5a Greenfield Road  Harborne  Birmingham  
B17 0ED

To find out more about our services please visit  http://www.pslconnect.com



Chris Allen wrote:
> 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