Does anyone know if there is a way to list all the tables<BR>in a MS Access database?
Oh yes, there is a way. :)<BR><BR>Check out this article at 4Guys:<BR><BR>Listing the Tables in an Access MDB Database using ASP<BR>http://www.4guysfromrolla.com/webtech/092298-2.shtml<BR><BR>Happy Programming!
Â*<BR> Yes!that prog.for listing the tables in a database was pretty useful.But how does one list the fields(fieldnames) and their corresponding datatypes of the table?
No problem also<BR>set rec = con.OpenScema(adSchemaColumns, Array(empty,empty, "YourTableName"))