ADO 2.1 / OpenSchema?

[JasonGS]

Does anyone know how to use ADO to A) get a list of table names and B) get the date & time that the table was last modified?

[Learning]

You can use ADO OpenSchema to get tablenames, but I am not sure whether you can get date using that.

[Clunietp]

'uses ADO 2.x and Ado 2.x Ext for DDL and Security
    Dim objCn As New Connection
    
    
    Dim objCat As ADOX.Catalog
    Dim objProc As ADOX.Procedure
    Dim objTable As ADOX.Table
    
    objCn.Open <connectionstring>
        
    Set objCat = New Catalog
    
    objCat.ActiveConnection = objCn
    
    For Each objTable In objCat.Tables
        Debug.Print objTable.Name & ":  " & objTable.DateModified
    Next objTable

    
    objCn.Close
    
    
    Set objCat = Nothing
    Set objCn = Nothing