Using the connection object to retrieve the tabledefs number

[Piazza]

Hi!

Does anyone know how do I get the tabledefs number I have in a database?

When I used the DAO, a wrote:

...
For i = 1 To db.tabledefs.Count - 1
debug.print db.tabledefs(i).Name
Next
...

How do I do the same thing using the ADO Connection?

Or, if possible, using another ADO object?

Thanks a lot!!!
[]'s
Marcelo Piazza