DBPROP_MSMD_USEEXISTINGFILE Property

Determines whether a local cube file is overwritten if the connection string contains CREATE CUBE and INSERT INTO statements.

Remarks

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.

See Also

DBPROP_MSMD_CREATE_CUBE

DBPROP_MSMD_INSERT_INTO

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.