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
Why and when do stored procedure recompile?
How many full-text indexes can a table have?
What is the fillfactor concept in indexes?
how would you improve etl (extract, transform, load) throughput?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
What is the maximum size of a row in sql server?
How to create a stored procedure with a statement block in ms sql server?
Explain the stored procedure?
how many no of arguments can be passed in procedures and functions
What can be used instead of trigger?
What the different topologies in which replication can be configured?
User wants only to display only pdf as export option in report manager. How to achieve this?
What is parameterized reports in ssrs ?
What is the difference between Normalization and De-normalization?
What is 2nf example?