VBA (Visual Basic for Applications) Question:
Explain What are the ADO objects?
Answers:
Answer #1The 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.
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.
Answer #2Super 1
Answer #3It's a bad question. The Ado object holds the properties that are listed. When you are instantiating an ADO object, you are creating the parent object which holds each one of those entities in the list.
| Previous Question | Next Question |
| Explain the difference between Msgbox Statement and MsgboxQ function? | What is function of delete operator? |