Performance Tip: Set table Subdatasheet Name Property to [None], or explicitly specify the name

Provided by: FMS Development Team

In Microsoft Access, subdatasheets are a valuable way to see one-to-many relationships from a table's datasheet view. However, if you do not want this, you may be suffering a performance penalty.

By default, the Subdatasheet Name property for tables is set to [Auto]. When the table is opened, the datasheet automatically looks for, and includes, a subdatasheet based on its table relationships. If you want this feature, it would be better to explicitly specify the subdatasheet table. If you do not want this feature, setting this property to [None] can significantly improve performance, especially over a network.

To change this property, put the table in design mode.

Our Total Access Analyzer performs detailed analysis of your Access database objects and detects this tip, as well as hundreds of others.