View Single Post

  #4 (permalink)  
Old 11-09-2005
Victor
 
Posts: n/a
Default 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?



Reply With Quote