Google Answers Logo
View Question
Q: For hammer-ga only ( Answered 5 out of 5 stars,   2 Comments )
Subject: For hammer-ga only
Category: Computers > Programming
Asked by: respree-ga
List Price: $2.00
Posted: 29 May 2003 12:47 PDT
Expires: 28 Jun 2003 12:47 PDT
Question ID: 210373
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.
Subject: Re: For hammer-ga only
Answered By: hammer-ga on 29 May 2003 12:58 PDT
Rated:5 out of 5 stars
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:

- Hammer
respree-ga rated this answer:5 out of 5 stars and gave an additional tip of: $73.00
Thank you.

Subject: Re: For hammer-ga only
From: julie99-ga on 29 May 2003 16:33 PDT
wow- is that tip correct?  Lucky you!
Subject: Re: For hammer-ga only
From: webadept-ga on 30 May 2003 11:47 PDT

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?


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


Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy