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 |
what are database files and filegroups? : Sql server database administration
What is the new security features added in sql server 2014? : sql server security
How to start and end transact-sql statements?
Can you have a nested transaction?
Which is the main third-party tool used in sql server?
How many types of database relationship in sql server?
Explain what is scheduled job and how to create it?
Plz tell about backup&recovery?
How to get number of days in a given year?
What is difference between clustered and non clustered index?
What to perform pattern match with the like operator?
Explain Geometry datatype in sql server 2008 with example
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)