Hello all,

I'm trying to use the ADODB.Catalog, as per some of Microsofts help file examples, but 'Catalog' does not appear as an option when I type in the following:

Dim cat as ADODB.Catalog

I am referencing the following libraries:

-Visual Basic for Applications
-Microsoft Access 11.0 Object Library
-Microsoft ActiveX Data Objects 2.1 library
-OLE automation.

I am trying to access the 'tables collection' from the 'catalogs collection'.

Thanks in advance for any help.