Code that shows how to work with Jet/Access objects and information using the ActiveX Data Objects (ADO) object model in VBA and VB6.

Procedure List

Procedure Name

Type

Description

(Declarations)

Declarations

Declarations and private variables for the modADOJetADOX module

ADOXCreateJetDatabase

Procedure

Create a new Jet database using ADOX

ADOXCreateLinkedJetTable

Procedure

Create a table link in the specified database using ADOX

ADOXGetTableProperties

Procedure

Get the properties of a table

ADOXGetLinkedPath

Procedure

Get the path where the specified linked table resides

ADOXGetLinkType

Procedure

Get a string identifying the type of object a linked table represents

ADOXIsTableLinked

Procedure

Determine 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