How to get table names from Access database?

How can I programmatically retrieve table names from an Access database using DAO/ADO?

Thanks.

VB Code:

For nCtr = 0 To MyDB.TableDefs.Count - 1
         Debug.Print MyDB.TableDefs(nCtr).Name
    Next