[This is preliminary documentation and subject to change]

## Update Records

###### Overview

This example demonstrates how your application can use ADO to update existing records.

###### Code Tour

CreateObject is used to create an instance of the Connection object, which in turn is used to open a connection to the OLE DB data provider. CreateObject is used again, this time to create an empty Recordset object. The ActiveConnection property is set to refer to the new Connection object.

The new recordset is then configured. The Recordset.Execute method takes a SQL command string as a parameter. This sample uses a SQL UPDATE command string to efficiently perform the update to the appropriate database records.

Important OLE DB must be properly configured on the server for this sample to run properly.

© 1997-2001 Microsoft Corporation. All rights reserved.