Re: Can one call an Access database on computer using the IP address?

On 29 Jul 2005 20:11:16 -0700, NC wrote:

>lkrubner@geocities.com wrote:
>>
>> An old friend of mine recently approached me and said something like:
>> "I've a computer at my office that has an Access database running on
>> it. We've most of our company info in there. We'd like to put a portion
>> of it online as a dynamic site, but we don't want the database to leave
>> our office. Our office is connected to the Internet through a static
>> IP. Can you do it?"
>>
>> I said no, but I also said I'd look into it. Could a PHP script running
>> on a web server make a call to that database to get info? How does that
>> work?
>
>Sounds doable with ODBC, as other posters have noted already. Define
>the Access DB as an ODBC source, have the server running PHP connect
>via ODBC. Security would obviously be an issue, and, possibly, so
>would performance. The way the task is defined right now, ASP may
>end up delivering better performance compared to a non-Microsoft
>solution such as PHP.

I haven't used ASP for a while, but I have created a few ODBC/PHP
sites. None of them have been *mega* busy sites and performance was
absolutely no problem.

I suspect that, as it will only be available to a select few <??> then
performance (with respect to concurrent users) wouldn't be much of a
problem. The only differences may occur if your d/b is *huge* - but
then carefully designed queries can still help.

Adam.
Received on Tue Oct 18 02:06:17 2005