En access 2021 Ultima propiedad de las "propiedades de tabla". Se llama "activar orden".

Question

En access 2021, me encuentro con la última propiedad de las "propiedades de tabla". Se llama "activar orden". Me viene con un 0 como valor predeterminado.

¿Qué utilidad tiene?

¿Qué valores puede tomar?

Gracias.

Answer 1

Answer 2

This is the OrderByOn property in English.  It causes the table to return rows in the order set as the OrderBy  (Ordenar por) property.  It accepts Boolean values of TRUE or FALSE, implemented as -1 and 0 in Access.

Answer 3

This property maybe have relation with orderby. But you can put 0 or -1 and dont change nothing when you go to table sight....It is indiference put 0 or -1

Answer 4

The OrderBy property must also be set to a value, which might be one or more column names, separated by semi-colons, or an expression. However, a better way to return rows in a specific order is by means of the ORDER BY clause in a query.