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 awe?

0 Answers  


What happens if you are trying to access a schema not owned by you?

0 Answers  


How do you use a subquery to find records that exist in one table and do not exist in another?

0 Answers  


How can you swap values between two rows in a table using single- SQL statement?

1 Answers   Tavant Technologies, Virtusa,


Define Unique Key?

0 Answers   HCL,






How to execute multiple stored procedures at one time in sql server?

0 Answers  


What do you understand by a view? What does the with check option clause for a view do?

0 Answers  


How to truncate a table first before running a package?

1 Answers  


How do I run sql server 2014?

0 Answers  


What is the difference between join and inner join?

0 Answers  


How do I find the query plan in sql server?

0 Answers  


How to write a query with an inner join in ms sql server?

0 Answers  


Categories