Learn More About ActiveX Objects

Program developers use ActiveX Objects to create programs that will allow them to access information with no knowledge about the database and how it is executed. You can employ ActiveX Objects in order to implement SQL commands but an understanding of SQL is not necessary in order to gain access to specific databases. What does this mean? It means that you have to reply on the kind of database you are using, which is a drawback.

So what exactly are ActiveX Objects? It refers to a series of Component Object Model (COM) objects that enable you to access various information from different places. It acts as a buffer connecting "Object Linking and Embedding" and encoding languages.

ActiveX Data Objects consist of 12 ActiveX Objects and four groups.

Groups (or Collections)

• Fields contain groups of "field objects" and can be utilized in a "Recordset" object.
• Properties consist of several "property" objects.
• Parameters can modify predetermined conditions and actions.
• Errors collection is part of a "connection object." The errors themselves are presented to an "Error Object Collection."

Objects

• Connection: This object collects and saves data and then presents the connection mode to the information saved.
• Command: Once the presentation to the data supply is confirmed, the directions are communicated via the "Command Object."
• Recordset: The Recordset is a collection of files that arrive from the "base table." The Recordset is made up pf a "Properties Collection" and a "Fields Collection."
• Immediate: The Recordset is restricted via the "adLockPessimistic" or "asLockOptimistic" and the information is revised at the base.
• Batch: The "adLockBatchOptimistic" restricts the Recordset. Each time a revision takes place it is revised accordingly.
• Transaction: When the "OLE DB Provider" allows, the Transaction Object is employed. To initiate the Transaction Object, you must start the "BeginTrans" and execute the appropriate revisions.
• Record: This characterizes one single record included in the main database.
• Stream: The Stream Object allows you to read and write a series of bytes.
• Parameter: The Parameter Object lets you modify the actions of a standard feature.
• Field: Fields are included in each "Record Object" and each "Record Object" has a matching "Field Object."
• Property: This is utilized to determine a function that has already been established.
• Error: When an ActiveX Object is employed and an error results an "Errors Object" is generated.

Microsoft is a registered trademark of Microsoft Corporation in the United States and/or other countries.