OLEDBConnection.MaintainConnection property (Excel)
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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for