Table 4.3. Query Specifications and Limitations
|
| Number of enforced relationships | 32 per table minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships |
| Number of tables in a query | 32 |
| Number of fields in a recordset | 255 |
| Recordset size | 1 gigabyte |
| Sort limit | 255 characters in one or more fields |
| Number of levels of nested queries | 50 |
| Number of characters in a cell of the query design grid | 1024 |
| Number of characters for a parameter in a parameter query | 255 |
| Number of ANDs in a WHERE or HAVING clause | AG99 |
| Number of characters in an SQL statement | Approximately 64,000 |
لطفا منتظر باشید ...
