Listing Tables Using ADO or DAO
Posted on 2005-04-19
Ive been contracted to write a program to update the data structures and tables of an Access database when the client deploys an updated version of their software. This will run initially and upgrade the database with the latest fields and tables as required.
However, im a little stumped as to how to read the table names from the MDB file. I cannot use constants for the table names in this case as the client will be using this program on several other projects as well.
Is there a way to list the tables of an Access database using either ADO or DAO, or is there perhaps another method which I am overlooking?
Thanks for your help.