Get Table-names automatically

frank_coyle
04-13-2004, 06: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!

MKoslof
04-13-2004, 08: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:

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

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum