Get Table-names automatically

Can't find this elsewhere and don't know if it's a stupid question but..

I'm connecting to an access database using ADO and i'd like to get a list of all tables in the database and list the names for the user to select a table.

I can get the column names after I have the right table, but I have to hardcode the table-name (which is what I'm trying not to do).

Thanks in advance for any ideas!

We have had this discussion many times. Here is a thread regarding the topic. A discussion I had with another member, there are code samples here too:

http://www.xtremevbtalk.com/showthread.php?t=142251