what are the main differences between ms access and sqlserver
Answer Posted / 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 View All Answers
What happens on checkpoint?
What are the different authentication modes in sql server? How can it be changed?
What happens if null values are involved in string operations?
How to provide values to user defined function parameters?
What is ms sql server service broker?
Explain throw statement in sql server 2008?
Can I run multiple instances of sql server 2000 at the same time on one computer?
How can you ensure that the database and sql server based application perform well?
How can you stop stored procedures from recompiling?
What are the grouping functions?
Tell me in brief how sql server enhances scalability of the database system?
How to convert numeric values to integers in ms sql server?
What is a select query statement in ms sql server?
What is logshipping and its purpose?
What is explicit mode in sql server?