1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

what are the main differences between ms access and sqlserver

Question Posted / jagan


what are the main differences between ms access and sqlserver..

Answer / appu

Access is installed as part of the Microsoft Office suite.
SQL Server can be quite expensive.
Access is more suited for desktop use with a small number of users accessing it simultaneously. One reason you might choose to use Access over SQL Server is for compatibility/sharing.
SQL Server was designed to have many hundreds, or even thousands of users accessing it at any point in time.

Is This Answer Correct ?    11 Yes 1 No

Post New Answer

More SQL Server Interview Questions

Different Types of Functions ?

2 Answers   Satyam,

What do you understand by triggers?

0 Answers  

Describe the functionalities that views support.

0 Answers  

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

5 Answers   IBM,

Which command displays the SQL command in the SQL buffer, and then executes it?

3 Answers   TCS,




1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

0 Answers  

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

0 Answers  

What are the disadvantages of using the stored procedures?

0 Answers  

What is openxml in sql server?

0 Answers  

Mention the command used to rename the database.

0 Answers  

wat is mean by normalization?......programing defination i need...(i know basic defination)

4 Answers   Wipro,

What is normalization and its forms?

4 Answers   Challenger Financial,

For more SQL Server Interview Questions Click Here
Categories