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.
Note: This is a feature of Access/JET
tables, and not for SQL Server tables.
FMS's Total Access Analyzer performs detailed analysis of your Access
database objects and detects this tip, as well as hundreds of others.
Find out more!
Return to the tips page
|
