Shulou(Shulou.com)06/01 Report--

This article to share with you is about the access database management system introduction, Xiaobian think quite practical, so share to everyone to learn, I hope you can read this article after some harvest, not much to say, follow Xiaobian to see it.

Microsoft Office Access is a relational database management system published by Microsoft. It combines Microsoft Jet Database Engine and graphical user interface features, is one of the Microsoft Office system programs.

Microsoft Office Access is a database management system that combines the graphical user interface of Microsoft Database Engine with software development tools. It is a member of Microsoft Office and is sold separately in office editions including Professional and higher versions. Microsoft Office Access 2013 was released on December 4, 2012 in Microsoft Office 2013, the previous version being Microsoft Office Access 2010.

MS ACCESS stores data in its own format in an Access Jet based database engine. It can also import or link data directly (stored in other applications and databases).

It combines Microsoft Jet Database Engine and Graphical User Interface, and is a member of Microsoft Office.

1. Advantages:

Access deployment is simple and convenient, on a file to use more flexible, mainly desktop database system, he can also develop based on their own desktop database applications (UI), can also be used as a front-end development tool with other database development applications (such as SQL Server, DB2, Oracle, etc.), skilled software designers and data analysts use it to develop applications, while some unskilled programmers and non-programmer beginners use it to develop simple applications.

2. Disadvantages:

Data storage is small and security is not high enough. It is easy to crack the user-level password. C/S structure on the server requirements are very high, otherwise it is easy to cause Mdb damage, concurrent number 255, but the adaptability to high-intensity operation is poor, if the server is not good enough, the network is not good enough, programming methods are not good enough, 6-7 people at the same time access can lead to Mdb damage or death, can not be VBA code development software system directly compiled into Exe executable files, can not be separated from Access or Access Runtime environment, the environment is relatively large compared to other software (about 50M).

Microsoft Access database has a certain limit, if the data reaches about 100M, it is easy to cause the server IIS to die, or consume the server's memory and cause the server to crash.

The above is an introduction to the access database management system, Xiaobian believes that some knowledge points may be seen or used in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.