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.

[kb244]

That depends on the size of the data, if you got like a couple thousand definitly a sql thing, also sql server is faster when it comes to working with a website, access is easier but it is always going to be slower, but in either case it depends on your bandwidth and your CPU speed as well.

If the database resides on the same machine as the webpage it won't be that slow, although only when doing not to big querys. If you need a lot of users at the same time, complicated querys or more then 1/2Gb of data you are better of useing an SQL-Server.