Performance of MS Access vs. SQL Server? 1

[Geomus]

Hello,

Could anyone tell me what the difference in performance and speed are between using a web application based on MS Access as opposed to one based on SQL Server? At what number of records & simultaneous users should one consider moving to SQL Server, if ever?

Thanks in advance!

Fedor Steeman

 

[Geomus]

The database will probably not exceed 500 MB in size for a very, very long time and there will probably not be more than 10 simultaneous users at one time. No urgent reason to switch to SQL Server then?

 

[evalesthy]

See if this helps you out.

http://www.microsoft.com/sql/evaluation/compare/access/whatsright.mspx