RefreshLocations

Applies to:

VAccess

RefreshLocations determines whether the VAccess control will use DDF files for meta data or whether it will use internal states and/or persisted properties for meta data. If RefreshLocations is True, then the VAccess control will act as a passthrough to the DDF files-all requests for meta data will be re-read directly from the DDF files.

Metadata manipulations will affect only the VAccess control's memory image of the metadata. You must explicitly call DdfAddTable, etc., in order to persist your changes.

If this property is True, the table metadata associated with the ActiveX Data Source control will be read when the control is instantiated. This property prevents the ActiveX control from constantly refreshing the DDF information.

If RefreshLocations is set to False, you can redistribute applications that use ActiveX without the corresponding set of DDF files, assuming the DDF set never changes, because ActiveX can persist DDF information.

Remarks:

To modify your DDF files:

Set RefreshLocations to True.

Retrieve the current DDF information (RefreshLocations = True, so it will be directly from the file).

Modify IndexList and FieldList as desired. The changes will be stored to the VAccess memory image)

Call DdfAddTable to commit the changes to the DDF files themselves.

Example

'Setting RefreshLocations to true will  
'enable the controls to read all the needed  
'information from the ddf files 
VAEngine.RefreshLocations = True 
VAEngine.DdfPath = path 
VAEngine.TableName = tableName 
VAEngine.RefreshLocations = False