Re: Difference between MySQL and MS Access
"Dennis Willson" <giganews@taz-mania.com> wrote in message
news:mZCdnbvyGN0z0OzenZ2dnUVZ_sGdnZ2d@baytsp.com.. .
>
>
> Gary L. Burnore wrote:
> > On Tue, 8 Nov 2005 17:02:22 -0500, "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.
> >
> >
> > You'll have to explain what you mean by "in by web FTP". FTP is a
> > protocal. Not a location.
> >
> >
> I'll bet his using the ftp server capabilities in IE and in IIS to upload files and he
doesn't have direct access to the web server.
> With Access if the odbc driver is setup, then just drop the database file in place and
it will work. No installation of executables.
I have access to a shared server using my FTP Client (FTP Surfer). I can just
drag-and-drop mydb.mdb into a subdir on my shared web, and - voila! - can access it from
my pages after setting up the driver.
The nice thing about it is, for FAST changes and mods, I can just double-click mydb.mdb
and it opens in Access. I can quickly add columns & change data if I wanted.
Now, compared to MS SQL, which is on a seperate server. The only way to view & modify
the database is by SQL commands - I can't directly view the database.
Can I use mySQL the same was as Access is described above?
|