Access .. The house in which they live data (2)
We talked last week about some of the obstacles faced by Alakss in proving the existence, and discussed the most important of those points in detail so that the reader a decent picture completely in the middle of what is going on this subject. And an update of this topic :
2-Others argue opponents of the use of Access to very slow in the flow of data on the internal network, but unlike some turtle race and Rabbit in reference to the slow Alakss in internal network compared with other databases.
Have agreed with them to some extent on this point, but I think it does not need a lot of applause and interpretations, it was learned that Microsoft tried to speak and improve the performance Alakss that has added tools to improve the performance of the internal networks of the institution, and perhaps most important of these tools is called Splitter or division. In a nutshell, the idea of the tool is that it is divided into two parts database containing the first models, reports and orders Micro modules, and any other organisms in the database, and the second contains tables that are stored data by, , and by the possibility Service Provider Network, which helps considerably-and through personal experience in the high-speed flow of data across internal network up to four or five times the previous speed. And explaining the idea from a technical point is that the store is the first section of the database, which contains reports and models, all organisms in the terminal organ network any employee who works on, for the large size, The second part of the database, which contains the tables are stored in the Service Provider Network, known as Server, and output of this process, when the operation of the database will have a computer which works employee from bringing all organisms and tables equipped with a server, because they already stored on the user, all that is done is to bring in the tables of Service Provider Network This will lead to the availability of data very quickly, just as we see the race boats, large Valekhout be slower than small boats to the weight size, and those small characterized contemptuously weight and high speed.
3-accuses the other opponents of the use of Access that slow during the search for the data, for example, when we in the search for partial certain records stored in the database, it takes a long time, and this phrase correct to a certain extent, even the mirror Bmaekerosowic to enter a new indexing data in the field as to the ease of searching the data in the field and the future known as Indexing, and find this option in the field characteristics in the design table. The program, which is designed to be available when search options in specific fields, because the search for a word or name in all fields to the database save a lot of time - and save a lot of wool top user of the program - and the result will undoubtedly be “no to Access after today.” The program authorized designer will be responsible for a large degree of this problem.
4-Security Access stronger-point raise Against this point-controversial of data directly affects the security and the ability to provide protection so that Microsoft has become Forests when talking about security in Access. And here - with apologies to Microsoft - they failed so far to provide security and protection of data stored in the database designed Balakss, and on each occasion the Microsoft enter new refinement to increase security in its program to convince developers and designers to use databases, Among these amendments, and the obstacles encountered :
A- Add a password for the database so that it can occupy program, introducing password, but unfortunately there were some small software which was able to extract any password database and show the user although it encrypted reservation, Therefore, the idea of using a password to the database is considerable naivete, here earn Against point in their favor against Microsoft.
B-as defined that can stop loading models in Alakss pressing a button “high” or Shift Your all organisms within the database, and the lovers Access preparation programs override this button so as not to allow the user to enter those organisms and any change out, In contrast Against the preparation programs reflect the process. If obtained the database was not able to halt loading models of everything you do is operating one of those programs and do this feature and here is another point in favor Against added. EX-added advantage of the Microsoft work groups, where they are preparing different groups and each group has specific conflicts of access to some models or reports, for example, financial personnel are not allowed to enter the pages dedicated to personnel officers and vice versa, until there is some sort of regulation in data entry, but this feature has been able Against the heroes of this win another point in their favor.
We are just going to talk so much in the hope that we will meet here next week and on the same day, God continue to talk about Alakss .. House, which houses the data.
NOTE: This is a machine translation.
