MS Access和Sql Server之间的主要区别 [英] Major differences between MS Access and Sql Server

问题描述

大家好，任何人都可以给出MS Access和Sql server之间的区别。在此先感谢。

解决方案

一个巨大的区别是Sql Server是一个数据库管理系统，而Access则不是。为什么我说这是在Access中，实际数据库操作的所有责任都分散在使用Access文件的客户端上。在Sql Server中有一个数据库引擎，负责实际操作，如文件处理，优化，内存管理等。



所以基本上是概念访问只使用共享文件，客户端驱动程序正在进行管理。在Access中，操作是通过客户端的文件操作完成的，而在Sql Server中，客户端使用SQL与数据库引擎通信。

http://www.quackit.com/microsoft_access/tutorial/microsoft_access_versus_sql_server.cfm [ ^ ]

http://forums.aspfree.com/microsoft-access-help-18/difference-between-ms-access-sql -server-99300.html [ ^ ]

HTTP：// w ^ ww.ehow.com/about_5380306_microsoft-access-vs-sql-server.html [ ^ ]

http://social.msdn.microsoft.com/Forums/en-AU/vbgeneral/thread/7139293d-8bca-492e-b6de-197d55ae751e [< a href =http://social.msdn.microsoft.com/Forums/en-AU/vbgeneral/thread/7139293d-8bca-492e-b6de-197d55ae751etarget =_ blanktitle =New Window> ^

Hello all, can anybody give the differences between MS Access and Sql server. Thanks in advance.

解决方案

One huge difference is that Sql Server is a database management system whereas Access is not. Why I''m saying this is that in Access all the responsibility of the actual database operations is scattered on clients using the Access files. In Sql Server there''s a database engine which takes the responsibility of actual operations such as file handling, optimization, memory management and so on.

So basically the concept for access is using just a shared file and the client side drivers are doing the management. In Access the operations are done via file manipulation from the client side whereas in Sql Server the client communicates with the database engine using SQL.

http://www.quackit.com/microsoft_access/tutorial/microsoft_access_versus_sql_server.cfm[^]
http://forums.aspfree.com/microsoft-access-help-18/difference-between-ms-access-sql-server-99300.html[^]
http://www.ehow.com/about_5380306_microsoft-access-vs-sql-server.html[^]
http://social.msdn.microsoft.com/Forums/en-AU/vbgeneral/thread/7139293d-8bca-492e-b6de-197d55ae751e[^]

这篇关于MS Access和Sql Server之间的主要区别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！