database driven website

[buddhad]

I need to design a database driven website that can support 80 users currently, this may go up. I have been using Microsoft Access and ASP for a smaller amount of users, but am not sure if this will be ok for the larger load.

Would Access/ASP be ok or should I switch to PHP/MySQL?

Thanks,

[mairving]

Access is a terrible web database. You will have some severe problems with 20 users or more. MySQL is much more robust, this forum runs on it.

[doctorgonzo]

Use PHP/MySQL. As mairving said, Access doesn't work well with more than 15 or 20 concurrent users. It was never intended to be much more than a single-tier, standalone database product.

[buddhad]

Thanks for the input. I think I will user your advice and go with PHP/MySQL.

[UncaDanno]

Uh, guys, if you are attaching to the database via a web page that allows anonymous access (that is, you don't have to log on to the server to gain access to the page), the "user" is most likely the intenet impersonator account (IUSR_machinename). Doesn't matter how many people are hitting the page, there is only one connection to the database (IIS' connection).

The real issue would be the volume of traffic and how big the database can/will get.

And, to paraphrase doctorgonzo, Access isn't really that well-suited for what appears to be what you need.

[chris1977uk]

access is ok, make sure u kill the connection string when its not being used anymore to save server resources etc.

i use access quite a bit, but for that many people id use ASP and my sql

(not a fan of php!)

[wilbasket23]

hei guys

i recently download the php development kit from php.net i have no clue how to configue my Window XP Pro. show my php page can show up in the internet explorer. can any one show me how to configure that show my php pages can show up in internet explorer. Also, do any of you know any commerical sites have free hosting on php. thax.