Get Table-names automatically

04-13-2004, 05:48 AM
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!

04-13-2004, 07:09 AM
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:

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum