G.3. The CurrentData Object
The CurrentData object is used to refer to objects stored within the current database by the server application (Access database engine or SQL). It has a variety of properties, described in the following table, that you can manipulate as well as several collections of its own.
Property | Data Type | Description |
---|---|---|
AllDatabaseDiagrams | AllDatabaseDiagrams collection | Represents the collection of database diagrams in the SQL Server database. |
AllFunctions | AllFunctions collection | Represents all the user-defined functions in the SQL Server database. |
AllQueries | AllQueries collection | Represents all of the queries defined in the database. This collection is empty in ADP files. |
AllStoredProcedures | AllStoredProcedures collection | References all of the stored procedures in the database. |
AllTables | AllTables collection | References all the tables in the database. |
AllViews | AllViews collection | References all views in the database. |
Get Access™ 2007 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.