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 command would you use to create an index?
What the different topologies in which replication can be configured?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
What happens if you are trying to access a schema not owned by you?
What is key attribute?
Why do we need different type of parameter?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
What is the difference between drop table and truncate table?
What is the importance of concurrency control?
How to rename databases in ms sql server?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What are the properties of the transaction?
How can you fetch alternate records from a table?
What are the triggers in sql?
What is SQL Azure Data sync?