"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: modADOJetADOX
Code that shows how to work with Jet/Access objects and information using the ActiveX Data Objects (ADO) object model.
|
Procedure Name
|
Type
|
Description
|
|
(Declarations)
|
Declarations
|
Declarations and private variables for the modADOJetADOX module
|
|
ADOXCreateJetDatabase
|
Procedure
|
Creates a new Jet database using ADOX
|
|
ADOXCreateLinkedJetTable
|
Procedure
|
Creates a table link in the specified database using ADOX
|
|
ADOXGetLinkedPath
|
Procedure
|
Returns the path where the specified linked table resides
|
|
ADOXGetLinkType
|
Procedure
|
Returns a string identifying the type of object a linked table represents
|
|
ADOXGetTableProperties
|
Procedure
|
Returns the properties of a table
|
|
ADOXIsTableLinked
|
Procedure
|
Determines if the specified table is a linked table
|
|
ADOXListJetTablesCollectionToString
|
Procedure
|
Uses ADOX to return a list of all items in the Tables catalog collection of the specified database.
Note that this collection contains tables and views, so be sure to look at the value of the Type property to determine which is which.
|
|
ADOXRelinkAllTables
|
Procedure
|
Relinks all the linked tables to another database (assumes all linked tables are linked to the same database)
|
|
ADOXRelinkTable
|
Procedure
|
Relinks a table to another database
|
|
ADOXTestAllLinkedTables
|
Procedure
|
Tests all linked tables in the specified database to see if the links are valid
|
|
ADOXTestLinkedTable
|
Procedure
|
Tests the specified linked table to see if its link is valid
|
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)
