Determines whether a local cube file is overwritten if the connection string contains CREATE CUBE and INSERT INTO statements.
This property’s name, which is used in the connection string, is UseExistingFile.
If the first character of this property’s value is Y, T, or a numeric digit other than 0 (zero), and the cube file specified in the DBPROP_INIT_DATASOURCE property already exists, the DBPROP_MSMD_CREATE_CUBE and DBPROP_MSMD_INSERT_INTO properties are ignored, and a connection to the existing local cube is established. If the DBPROP_MSMD_USEEXISTINGFILE property is not used, or the first character of this property’s value is not Y, T, or a numeric digit other than 0 (zero), and the cube file specified in the DBPROP_INIT_DATASOURCE property already exists, the statements in the DBPROP_MSMD_CREATE_CUBE and DBPROP_MSMD_INSERT_INTO properties overwrite the existing cube file.
This property’s value is used when a session is established, but the value cannot be changed during the session.