Comments inline.

"Michael Vilain" <vilain@spamcop.net> wrote in message
news:vilain-099A4A.16253108112005@comcast.dca.giganews.com...
> In article <VvSdndcmyrwTvezenZ2dnUVZ_tadnZ2d@comcast.com>,
> "Victor" <VicMoore028@yahoo.com> wrote:
>
>> Nice thing about MS Access is it can be installed in my web FTP and I can
>> make fast
>> changes to the database by double-clicking in FTP view.
>>
>> Does MySQL install via my web's FTP the same way? Or is it on a remote
>> server
>> like MS
>> SQL?
>>
>> (I'm not that concerned with user bandwidth, it's a restricted intranet.)
>
> Not sure what you're asking as you're not to clear in your request. If
> you mean "Can I update or manage a database remotely?", the answer is
> yes. There's phpMyAdmin, a web-base MySQL administration tool:
>
> http://www.phpmyadmin.net/home_page/
>
> Since you have to pay for MS Access

True... (Well, mostly. There are "evaluation" versions available. :) )

> and it only runs on Windows locally
> on your desktop,

False.
This must be split into 2 categories:
1 - MS Access as a front-end tool can be used over various remote desktop
technologies. It can and does connect easily to almost every type of
database out there.
2 - MS JET database (which is what the poster appears to refer to) can be
set up as a backend database on a web server interface. It isn't that much
harder or different than any other method of database deployment. It
actually runs quite clean when the DB resides on the web server.

> how would you run it as the backend database for a web
> site?

Like anything else, if you set up your server properly, it will work just
fine.

> MySQL, php, and Apache can do this for free.

False... well that depends really on your MySQL deployment and use scenario.
If the service is free and you stand to gain nothing from it's
implementation, and meet some other criteria then it seems to be generally
understood that it is free. Other wise you must purchase a license.

Opensource != Freeware: Read_the_license

> --
> DeeDee, don't press that button! DeeDee! NO! Dee...

Personally, if the implementation is small, and you have a lot of control
over the web server, MS JET will work just fine as a database. If it starts
to amass a lot of data and users, then it is time to move up to a full
server based DB that can handle concurrent calls and faster response rates.

I think MySQL would be a good choice (irregardless of licensing needs).

However, the poster is not clear about how his database is interfaced or
used with his web site. It all depends on the needs of the implementation.

~ Duane Phillips.