E.2. The CodeData Object
The CodeData object is used to refer to objects stored within the code database by the source application (Jet or SQL). The CodeData object has a variety of properties you can manipulate as well as several collections of its own.
E.2.1. Properties of the CodeData Object
The following table lists the various properties of the CodeData object.
| Property | Data Type | Description |
|---|---|---|
| AllDatabaseDiagrams | AllDatabaseDiagrams collection | Used to reference the AllDatabaseDiagrams collection |
| AllFunctions | AllFunctions collection | Represents all the user-defined functions in the SQL Server database |
| AllQueries | AllQueries collection | Used to represent all of the queries defined in the database |
| AllStoredProcedures | AllStoredProcedures collection | Used to reference all of the stored procedures in the database |
| AllTables | AllTables collection | Used to reference all the tables in the database |
| AllViews | AllViews collection | Used to reference all views in the database |
Get Access 2003 VBA Programmer's Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
