This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

ActiveX Data Objects (ADO)

Programming objects that represent the structure of your database and the data it contains. In the Visual Basic Editor, you can use ADO objects and an additional component of ADO called Microsoft ADO Extensions for DDL and Security (ADOX) to create or change tables and queries, secure your database, or access data from external data sources. You can also use ADO objects in code to manipulate data stored in your database. ADO and ADOX support access to any data source that has an ODBC driver or OLE DB provider created for that data source. This includes Access databases (.mdb files), through the OLE DB Provider for Microsoft Jet 4.0, and SQL Server 6.5 and 7.0 databases, through the Microsoft OLE DB Provider for SQL Server.