Muokkaa

Jaa

OLEDBConnection.MaintainConnection property (Excel)

  • Artikkeli

Returns True if the connection to the specified data source is maintained after the refresh operation and until the workbook is closed. Read/write Boolean.

Syntax

expression.MaintainConnection

expression A variable that represents an OLEDBConnection object.

Remarks

The default value is True. If you anticipate frequent queries to a server, setting this property to True might improve performance by reducing reconnection time. Setting this property to False causes an open connection to be closed.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.