How to get the list of tables in a MS Access database using ADO?

[Raptors Fan]

Hi all,

New to ADO. I need to get the names of all the tables in an Access database using ADO and VB6.
I need to check if the table exists in the database before running a query done on the fly.

Thank you.