[objekt404]

i'm stuck.  does anyone out there know how to retrieve a list of tables inside an .mdb through sql?

[objekt404]

possible solution to this problem (please, allow me to suck some more space here...):

each of the .mdbs will have a ToC-table.  simple, neh?  took 3 pots of coffee & 'bout an hour of random conversation w/my uncle to spur that one!

...though if anyone *does* know how to retrieve a table list from a DB i'd still be interested in seein' it

[The Neoracle]

You just want a list of the tables in a database?  That's simple (in MySql).  Use the SHOW TABLES FROM db_name statement.  I don't know if you are using MySql or something else, and if that something else has that function, but MySql does and that's all I've got experience on.  Plus, why would you need anything else? ;)  

[objekt404]

that sounds like the ticket, but all i got is access :(
i *wish* i knew where to get some better software, but i really haven't had the time or bandwidth.
thanks for the pointer though, i'll definitely have to learn more about *other* DBs than plain access ('specially if i plan to make money at this ;)

[IceStorm]

Take a look at the following URL:

http://www.asp101.co...=db%5Fdsn%2Easp

It explains exactly how to do this.

[The Neoracle]

**Cough** http://www.mysql.com/ **cough**  It's FREE!

[objekt404]

Quote

Quote: from The Neoracle on 1:47 pm on Nov. 7, 2001
**Cough** http://www.mysql.com/ **cough**  It's FREE!

yes, but i'm not hosting it myself.  i dunno what their running, but i'll ask 'em 'bout mySql