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

How do I find the port number for sql server?

0 Answers  


What is the difference between update lock and exclusive lock?

0 Answers  


What is policy management?

0 Answers  


Does a server store data?

0 Answers  


What is the correct order of the logical query processing phases?

0 Answers  






can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?

1 Answers  


sql server syntax to add "!" sign to "name" field of "employee" table in a manner that all names have the same lenght of 20 characters

1 Answers  


which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help

3 Answers  


How to return the second 5 rows in ms sql server?

0 Answers  


CTE(common table expression)

1 Answers   Thomson Reuters,


Explain about SQLOS?

0 Answers  


What are the purposes and advantages stored procedure?

0 Answers  


Categories