This documentation is archived and is not being maintained.

ODBCConnection.RobustConnect Property

Office 2007
Returns or sets how ODBC connection connects to its data source. Read/write XlRobustConnect.

Version Information
 Version Added:  Excel 2007



expression   A variable that represents an ODBCConnection object.


If you use robust connectivity, when Microsoft Excel is unable to establish a connection using the workbook connection information, Excel will check if the workbook connection has a path to an external connection file. If it does, Excel will open the external connection file and try to connect using the information contained in the external connection file. If a connection can be established after using the external connection file, Excel will then update the workbook's connection object.

This provides robust connectivity in scenarios where an Information Technology Department maintains and updates connections in a central place, permitting a user's workbook to automatically fetch those updates whenever the previous version of the connection (cached within the workbook) fails.

Bb224500.vs_note(en-us,office.12).gif  Note
Robust connectivity isn’t secure. If you create a connection on your computer and use it in a workbook and then send someone the workbook, that person will be able to see the path to the connection file on your computer. It is a good idea to remove the connection file information from the workbook before you send the workbook to someone else.