"The code is exactly
how I would like to write code and the algorithms used are very
efficient and well-documented."
Van T. Dinh, Microsoft MVP
|
|
|
Category:
|
Database : Access/Jet
|
|
Description:
|
Microsoft Access Jet databases and their objects (MDB and ACCDB database formats)
|
Module: modJetObjectInfo
Detailed information on individual Jet/Access objects using the Data Access Objects (DAO) object model
|
Procedure Name
|
Type
|
Description
|
|
(Declarations)
|
Declarations
|
Declarations and private variables for the modJetObjectInfo module
|
|
BuildDictionaryToArray
|
Procedure
|
Builds a dictionary of Data Access Objects to an array.
This includes tables, fields, queries, indexes, relations, forms, reports, macros and modules. The array is populated with both the object type and name in the form: [ObjectType][ObjectName]. For example, a table named 'Customers' appears in the array as [Table][Customers].
|
|
BuildDictionaryToTable
|
Procedure
|
Builds a dictionary of Data Access Objects to a table.
This includes tables, fields, queries, indexes, relations, forms, reports, macros and modules. The table populated is named 'tbl_DAO_Dictionary'. If the table doesn't exist, it is created. If it does exist, it is first emptied of records. The array is populated with both the object type and name in the form: [ObjectType][ObjectName]. For example, a table named 'Customers' appears in the array as [Table][Customers].
|
|
DumpDAOToText
|
Procedure
|
Dumps the DAO structure of the database to a text file.
This function creates a text file containing a list of objects in the current database, and optionally, their property names and values. If a path is omitted in the 'strFile' parameter, the file is created in the current directory.
|
|
DumpDAOToText_WriteOutput
|
Procedure
|
Writes the string out to the file. This is a private helper function used by DumpDAOToText().
|
|
DumpDAOToText_WriteProperty
|
Procedure
|
Writes the name and value of the supplied property. This is a private helper function used by DumpDAOToText().
|
|
GetQueryType
|
Procedure
|
Returns the type of the named query: Select, Action, Crosstab, Delete, Update, Append, Make-table, Data-definition, Pass-through, or Union.
|
|
IsObjectInDB
|
Procedure
|
Determines if the named object is in the named Jet database
|
|
NumberObjects
|
Procedure
|
Returns the number of objects in a database, including tables, queries, forms, reports, macros, modules and relationships are included.
System objects (such as the MSYS... tables) are not counted.
|
|
ObjectsToArray
|
Procedure
|
Populates the supplied array with a list of object names of the specified type
|
|
ObjectsToString
|
Procedure
|
Populates the supplied string with a delimited list of object names of the specified type
|
|
QueryFieldsToArray
|
Procedure
|
Populates the passed array with a list of fields in the named query
|
|
QueryFieldsToString
|
Procedure
|
Populates the passed string with a list of fields returned by the named query
|
|
QueryParametersToArray
|
Procedure
|
Populates the passed array with a list of Parameters returned by the named query
|
|
QueryParametersToString
|
Procedure
|
Populates the passed string with a list of Parameters returned by the named query
|
|
RelationFieldsToArray
|
Procedure
|
Populates the passed array with a list of fields in the named relation
|
|
RelationFieldsToString
|
Procedure
|
Populates the passed String with a list of fields in the named relation
|
Overview of Total Visual SourceBook
The source code in Total Visual
SourceBook includes modules and classes for Microsoft Access, Visual
Basic 6 (VB6), and Visual Basic for Applications (VBA) developers. Easily
add this professionally written, tested, and documented royalty-free code
into your applications to simplify your application development efforts.
Additional Resources
|
|
All Our Microsoft Access Products
(885K)
