1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

what are the main differences between ms access and sqlserver

Question Posted / jagan


what are the main differences between ms access and sqlserver..

Answer / 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

More SQL Server Interview Questions

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

Write a program using SQL queries to find a unique entry in a table.

0 Answers   Tech Mahindra,

Accidentally i deleted my table. How can i get that table?

4 Answers  

Do you know data definition language, data control language and data manipulation language?

0 Answers  

What is the difference between writing data to mirrored drives versus raid5 drives

0 Answers  




What is difference beteen Migration and Upgrdation?

7 Answers   Satyam,

What are the different types of stored procedures?

0 Answers  

What is an expensive query?

0 Answers  

Explain what is “asynchronous” communication in sql server service broker?

0 Answers  

What is the main difference between ‘between’ and ‘in’ condition operators?

0 Answers  

Can we use pragma autonomous_transaction in trigger?

0 Answers  

How do you simulate a deadlock for testing purposes

1 Answers  

For more SQL Server Interview Questions Click Here
Categories