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 are the different types of backups avaialabe in sql server 2005?
How will you find out if there are expensive SQL statements running or not?
What is the process of normalising?
What do you mean by data manipulation language?
Define tempdb database?
What is the Control Flow in SSIS
How to enable/disable indexes?
How to start and end transact-sql statements?
Write a SQL queries on Self Join and Inner Join.
How to get a list all databases on the sql server?
What are 3 ways to get a count of the number of records in a table?
what is blocking? : Sql server database administration
What is the purpose of sql profiler in sql server?
What do you mean by 'normalization'?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?