Call Close to set the Active property of a dataset to False. When Active is False, the dataset is closed; it cannot read data from or write data to the database.

An application must set Active to False before changing other properties that affect the status of the database or the controls that display data in an application.

For example, to change the DataSource property for a dataset, the dataset must be closed. Closing the dataset puts it into the dsInactive state and closes the cursor.