Professionals do not know what for Microsoft Access

Ask a lot more about the ability of database application Microsoft Access Database to carry data, and how much of the conversations and rumors that revolve around the obvious answer to this question.

Let us first talk in some detail for Microsoft Access:

Being arrived at this link or the subject you are undoubtedly one of the gawkers News You Qguaaadalbianat a strong connection to this area and this I will avoid talking about the definition of what databases, etc., for you of course know more than me in that.

But what we said about MS ACCESS is precisely is a microcosm of the applications and management systems, relational databases, or RDBMS, and provides MS ACCESS users the kind of ease and convenience during use as well as isotopes, referred to earlier, such as Microsoft SQL Server, My SQL Server or ORACLE or Sybase ... etc..

Let me say about the Egyptian Balijhetti Aloksys compared to previously mentioned that it is a (sandwich database) ... Means something like that in fast!!

But this does not prevent a potent force in MS ACCESS, which Senberzha shortly after ... But here, let us turn to something very important:

Q: What is the motivation that makes you feel like (You are a professional programmer) to use MS ACCESS????
A: If checked in the question, I went to professional ... Response simply because the client Kintejpllthalil environmental systems analysis your work or its business may show us Admujub use a huge database such as SQL Server or ORACLE .... Etc, but we have seen as money - according to the test and analysis - that the database MS ACCESS Mlaimpjadda.

Q: As a professional programmer, what do you know about MS ACCESS in terms of advantages and disadvantages???
A: The capacity of small and bear a lot of data but do not know exactly how nine, and I have also learned to limit maximum number of objects to be borne by Hadpalbianat, and that it disadvantages as well as slow data transfer on the network and Ilyzlk, and are not a large number of users.

I come here regularly ... And I will tell you the following:
Have had the answer in the first question.
The second question, the answer is not a professional answer, they are not adequate and not accurate.
**********************************************


Come with me in this short tour we will talk about the Microsoft ACCESS Database Application.

** For an overview of the database:
Microsoft ACCESS database or the name of the subsequent stretch (mdb or accdb) is a collection or set of data and objects to contain input and output data and perform various operations on them.
Storage capacity does not exceed the (2 GB, 2 GBs), and the space containing the above-mentioned data in addition to the storage space occupied by the database objects such as tables, queries, modules and stored procedures.
Does not assume that the database containing the objects inside the above-mentioned in the previous point, more than 32,768 of an object.
Microsoft says that the application of MS ACCESS can afford the convergence and synchronization of user 255 at the same time, but says that this number will decrease Bkthirotina the Design-Time.
** Overview of the tables:
The number of schedules that can carry data base is the same Adeddalkainat in general that database can carry this on the basis that the rule does not contain within it the tables but only a previous issue (32,768).

As we have done with the maximum of the objects, we'll do it again Amaalmessahp, and here I mean a table can contain 2 GB of data and include the necessary size of the *******s of the database and this, as the Hadpalbianat contain only this table.
You can not rename the table a text string length of more than 64 characters.
As well as for fields apply to them as they relate to the name of the table.
Number of tables open as we have received from Microsoft is 2048, and are intended as the number of tables open at the same very moment, but in reality this figure is a lot and that because the application of the MS ACCESS tables Bakth internally without showing a physical material in front of you.
Go back a second space or storage capacity of a maximum of (2 GB), and to mention if you are from users of MS ACCESS 2000 or 97 will not receive, b (1 GB only), though the good fortune to and you are using versions of the finest Mnzlk will be allies of the (2 GB).
Here's the information: We all know the notes fields of the type (Note / Memo), you risk your mind how nine of those fields?? ........ Nine of those fields the amount of characters the number of (65.535) and this if you've entered data through the interface that is MS ACCESS User Interface but if you entry programmatically, then you can imagine that this field has been transformed into a deep well can the data *****alent of (1 GB ), but do not ask me why because it is a physical process related to motor MS ACCESS personally and let's not interfere in the affairs of others. Hahaha.
For fields of type (OLE) is equal to the nine (1 GB) of data.
A table can not contain more than 32 inside index / Index.
The number of characters that can they contain fields with the exception of the (Memo, OLE) when the property (UnicodeCompression) value equal to Yes are as follows: the same with the version of 2003 = 4000 characters or for the version of XP = 2000 characters.


** Overview of Information:
Maximum of relationships within a single query is (32), including the relationship of the indexes, this means that if the indexes included the tables query = 5 indexes, this query will not contain more than 27 relationship Enforced Relationship.
The number of tables listed query no more than 32 table for each query.
One can not record that contains more than 255 field.
Each record within the query to no more than (1 GB).
Number of levels of Information graduated Nested Queries do not exceed the 50 level.
Phrase query for the query can carry around (64.000 characters) inside.
** Glimpses into the reports and forms:
Address box (Label) can carry 2048 characters.
The text box (TextBox) can carry 65 535 characters.
Maximum width of the report or of the form = 22 inches, or, 55.87 cm.
The length of each section = 22 inches, or, 55.87 cm.
Total length of Sections Sections at design time in addition to the top of the object (form or report) = 200 inches, or 0.508 cm.
Number of levels of reports and forms graduated as follows: in version 2003 and XP up to 7 levels, either version 2000 and older are only 3 levels.
You can use (10) fields of the work of sorting and compiling a maximum of ... Sorting and Grouping.
You can only use the number (1) Report / Page Header / Footer, but you can use (10) Group Header / Footer.
Single report can not contain more than (65,536 pages) for printing.
You can not add or drawing tools than 754 tool on the form or report, and tools are well known, such as the Address box and command button, the figure includes the above-mentioned number of partitions in the form or report.


We have successfully