Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Why and when do stored procedure recompile?

927


How many full-text indexes can a table have?

926


What is the fillfactor concept in indexes?

933


how would you improve etl (extract, transform, load) throughput?

968


What is the guest user account in sql server? What login is it mapped to it? : sql server security

1005


What is the maximum size of a row in sql server?

903


How to create a stored procedure with a statement block in ms sql server?

985


Explain the stored procedure?

990


how many no of arguments can be passed in procedures and functions

5459


What can be used instead of trigger?

1096


What the different topologies in which replication can be configured?

1019


User wants only to display only pdf as export option in report manager. How to achieve this?

247


What is parameterized reports in ssrs ?

139


What is the difference between Normalization and De-normalization?

1028


What is 2nf example?

938