Is MS Access suitable for running on a web server (lets say to store
inventory information)?

If so, what are some its disadvantages when compared a MySQL database?

Thanks very much for your help.

Access is suitable for smaller applications. It is not as robust as
mySQL, as far as simultaneous connections. mySQL will tend to be
faster and (in my opinion) a better choice for web server use. Access
would be a better choice for you for offline use because it has a GUI
interface, whereas mySQL needs a separate GUI interface attached to
the engine.

There is a nice manual for mySQL at mySQL:
http://www.mysql.com/doc/en/index.html

- Hammer

Thank you.

wow- is that tip correct?  Lucky you!

Hi, 

MySQL is free, the program phpMyAdmin does give it a very nice web
interface, but it is not required. MySQL has it's own interface, not a
separate one. It is 67% faster in large loads and large database
searches than Access, crashes less (read 'never'), and is fully
supported by Apache and IIS. Perl and PHP programs can access it
easily.. oh, did I mention it was free?

HTTP://WWW.MYSQL.ORG

http://www.phpwizard.net/projects/phpMyAdmin/

There is a new book out from O'Reilley , the MySQL Cookbook which is
fantastic.

webadept-ga