Speed of Access vs SQL Server

[randyv]

Does anyone have any data for the speed of retrieving from Access vs SQL Server. I am putting together a web site that will be making an average to above average number of hits to a database and am trying to determine if SQL Server will be necessary. Any help would be appreciated.

[JHausmann]

What kind of machine do you plan on runing your DBMS?
How much memory will be available?
How many processors will be available?
How large do you expect your tables to get?
How many users will be concurrently accessing the database?
Will there be data retrieval and data input happening at the same time?

[randyv]

It will be a dual processor PIII 550, average of 15-20 concurrent users, There will be about 10 tables half of which will have 100 records or less, 2-3 will have between 100-500, and 2 will grow slowly to 1000+. And yes, there will be data read and writes at the same time.

Thanks

[JHausmann]

It's the number of concurrent users that will decide which DBMS is better for you. 15 is the number I've heard to be tops for concurrent ACCESS usage. It'll do you little good to have performance numbers if Access can't support your estimated users.