ADO methods

Applies to: Access 2013, Office 2013

Method	Description
AddNew	Creates a new record for an updatable Recordset object.
Append	Appends an object to a collection. If the collection is Fields, a new Field object may be created before it is appended to the collection.
AppendChunk	Appends data to a large text or binary data Field, or to a Parameter object.
BeginTrans, CommitTrans, and RollbackTrans	Manages transaction processing within a Connection object as follows: BeginTrans — Begins a new transaction. CommitTrans — Saves any changes and ends the current transaction. It may also start a new transaction. RollbackTrans — Cancels any changes and ends the current transaction. It may also start a new transaction.
Cancel	Cancels execution of a pending, asynchronous method call.
CancelBatch	Cancels a pending batch update.
CancelUpdate	Cancels any changes made to the current or new row of a Recordset object, or the Fields collection of a Record object, before calling the Update method.
Clear	Removes all the Error objects from the Errors collection.
Clone	Creates a duplicate Recordset object from an existing Recordset object. Optionally, specifies that the clone be read-only.
Close	Closes an open object and any dependent objects.
CompareBookmarks	Compares two bookmarks and returns an indication of their relative values.
CopyRecord	Copies a file or directory, and its contents, to another location.
CopyTo	Copies the specified number of characters or bytes (depending on Type) in the Stream to another Stream object.
CreateParameter	Creates a new Parameter object with the specified properties.
Delete (ADO Parameters Collection)	Deletes an object from the Parameters collection.
Delete (ADO Fields Collection)	Deletes an object from the Fields collection.
Delete (ADO Recordset)	Deletes the current record or a group of records.
DeleteRecord	Deletes a file or directory, and all its subdirectories.
Execute (ADO Command)	Executes the query, SQL statement, or stored procedure specified in the CommandText property.
Execute (ADO Connection)	Executes the specified query, SQL statement, stored procedure, or provider-specific text.
Find	Searches a Recordset for the row that satisfies the specified criteria.
Flush	Forces the contents of the Stream remaining in the ADO buffer to the underlying object with which the Stream is associated.
GetChildren	Returns a Recordset whose rows represent the files and subdirectories in the directory represented by this Record.
GetChunk	Returns all, or a portion of, the contents of a large text or binary data Field object.
GetRows	Retrieves multiple records of a Recordset object into an array.
GetString	Returns the Recordset as a string.
LoadFromFile	Loads the contents of an existing file into a Stream.
Move	Moves the position of the current record in a Recordset object.
MoveFirst, MoveLast, MoveNext, and MovePrevious	Moves to the first, last, next, or previous record in a specified Recordset object and makes that record the current record.
MoveRecord	Moves a file, or a directory and its contents, to another location.
NextRecordset	Clears the current Recordset object and returns the next Recordset by advancing through a series of commands.
Open (ADO Connection)	Opens a connection to a data source.
Open (ADO Record)	Opens an existing Record object, or creates a new file or directory.
Open (ADO Recordset)	Opens a cursor.
Open (ADO Stream)	Opens a Stream object to manipulate streams of binary or text data.
OpenSchema	Obtains database schema information from the provider.
Read	Reads a specified number of bytes from a Stream object.
ReadText	Reads a specified number of characters from a text Stream object.
Refresh	Updates the objects in a collection to reflect objects available from, and specific to, the provider.
Requery	Updates the data in a Recordset object by re-executing the query on which the object is based.
Resync	Refreshes the data in the current Recordset object, or Fields collection of a Record object, from the underlying database.
Save	Saves the Recordset in a file or Stream object.
SaveToFile	Saves the binary contents of a Stream to a file.
Seek	Searches the index of a Recordset to quickly locate the row that matches the specified values, and changes the current row position to that row.
SetEOS	Sets the position that is the end of the stream.
SkipLine	Skips one entire line when reading a text stream.
Stat	Gets statistical information about an open stream.
Supports	Determines whether a specified Recordset object supports a particular type of functionality.
Update	Saves any changes you make to the current row of a Recordset object, or the Fields collection of a Record object.
UpdateBatch	Writes all pending batch updates to disk.
Write	Writes binary data to a Stream object.
WriteText	Writes a specified text string to a Stream object.