O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

PropertyData TypeDescription
AllDatabaseDiagramsAllDatabaseDiagrams collectionRepresents the collection of database diagrams in the SQL Server database.
AllFunctionsAllFunctions collectionRepresents all the user-defined functions in the SQL Server database.
AllQueriesAllQueries collectionRepresents all of the queries defined in the database. This collection is empty in ADP files.
AllStoredProceduresAllStoredProcedures collectionReferences all of the stored procedures in the database.
AllTablesAllTables collectionReferences all the tables in the database.
AllViewsAllViews collectionReferences all views in the database.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required