With a small number of users, MS Access is easy to handle and suited for desktop use
Easy compatibility and sharing compare to MS SQL Server
SQL server is, usually, used by developers and in a bigger organization
MS Access is cheaper than MS SQL
MS Access requires less database administration
If you like this question & answer and want to contribute, then write your question & answer and email to freewebmentor[@]gmail.com. Your question and answer will appear on FreeWebMentor.com and help other developers.