|
Free Resources from FMS |
|
|
|
|
"Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities." - Darren D. |
|
|
|
|
Microsoft
Access Resource Center
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!
