what are the main differences between ms access and sqlserver



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

What is #temp and @table variable in SQL server?

0 Answers  


What are the different types of sql server replication? : sql server replication

0 Answers  


What are the different types of backup avaible in SQL SErver

6 Answers   Emphasis, IBM,


What is the maximum size of a row in sql server?

0 Answers  


How to get the definition of a trigger back?

0 Answers  






How to get the definition of a stored procedure back?

0 Answers  


Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

0 Answers  


What is surrogate key? : sql server analysis services, ssas

0 Answers  


What is the difference between having clause and where clause in sql server?

0 Answers  


How many categories of functions based their return modes?

0 Answers  


I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?

3 Answers  


What is the difference between DTS and SSIS?

3 Answers   Allianz,


Categories