MySQL vs MS Access

Hi.

is MySQL better than MSA !???   Why !!!

Can I get a program/app free where it is easy to make database like in MSA just now in MySQL !???  Where and the name of the program !???

How can I run MySQL om my ISS SERVER WIN XP PRO !?? or is the MySQL just running fine whitout any updates !???

I have ISS 5,1 or 5,2 do I have to update to 6,0 and where can I find that for free !??

I hear that MySQL is superior to Access in terms of security and speed. I currently run access db but am thinking about migrating over to MySQL.

I am not a technical person, is migrating over to the MySQL version of Webwiz something that most beginners have a tough time with, or is it fairly intuitive? Will I need to have any special software to update the MySQL db (ie; I didn't need MS Access program to create access db...).?

Any suggestions/testimonals would be appreciated.

wgsnow wrote: One other thing, you will not be able to run Mysql on IIS. You need to download the Apache server (which is free), and then install Mysql over it.

It is not true. MySQL and IIS has nothing to do. IIS is a server for web, MySQL is a server for databases. As long you have installed the right connector drive, you can connect to any type of database MySQL, Oracle etc. Off course, there is the mySQL server that you need to install, and also a tool like mySQL Front (a sort of Enterprise manager equivalent) to help you administrate it. I have build an entire application that works on access/mysql/mssql. There are several changes that you have to make in order to port an app from 1 db to another. Access and MS SQL works almost hand in hand (natural they have the same provider), but still you need to made some adjustments. On the other hand, mySQL handles different some of the things. Also, it does not support stored procedures and some of the asp automatization like rs.recordcount, rs.absolutepage a.s.o. If you know some programming, you can make the necessary adjustments, else...
The wwg forum cannot be ported to mySQL. It is a well documented discussion I'm sure you will find arround here if you dig deep enough. I'm afraid that if you want to use it, you have no other choice but to by a MS SQL server db. Or switch to another forum software that works on asp with mysql. I have found one but I'm afraind I can remember where. Search on aspin.com. But for sure you would not find one better than wwg forum.

It seems you are confusing MySQL and MS SQL as being the same thing. They are NOT the same database. MySQL is a free (and I belive it is also open source, not sure about this though) database that was originaly developed for Linux, and is the popular choice for PHP and Linux based web applications, although it can be used with ASP just as easily if you have the database driver installed on the webserver. MS SQL is a enterprise database that is not free (it is actually quite expensive) written by Microsoft and is one of the more popular databases used in ASP web applications (along with MS Access). This is why MS Access and MS SQL are so easy to switch between. MS SQL is made for Windows based servers whereas MySQL will run on either Windows or Linux.

I can't import my access db to mySQL??    I've seen numerous threads on this here, but never looked at - I thought this was a common thing??

I imagine you can import your access db to MySQL, but like was said earlier, Access and MySQL syntax and built in procedures/functions are quite different and you will have to edit your code to allow it to work with MySQL.

Hope this clears things up.

Edited by Flamewave