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 is apply operator in sql?
What is collation sensitivity? Explain different types.
What is checkpoint process in the sql server?
How to make a remote connection in a database?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What are the advantages of sql stored procedure?
Explain what are the restrictions while creating batches in sql server?
What are the difficulties faced in cube development? : sql server analysis services, ssas
Why use triggers?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
What is a cache in ssrs?
How will you monitor replication latency in transactional replication? : sql server replication
Explain how to send email from sql database?
What is difference between unique and primary key?
How do I find the port number for sql server?