VBA (Visual Basic for Applications) Interview Question:

Explain What are the ADO objects?

Submitted by: Administrator

The ADO objects are:

Command
Connection
Error
Field
Parameter
Property
Record
RecordSet
Stream

Connection: Used to make a connection between your app and an external data source, i.e., sql server. Command: Used to build queries, including user-specific parameters, to access records from a data source (which are returned in a Recordset) Recordset: Used to access records returned from an SQL query. With a recordset, you can navigate returned records. You can also add, modify or delete records.
Submitted by: Administrator