how to: get table names from access

[dcmagain]

i am having issues with my home pc right now and i cant run iis
so if i want to work from home, i need to build some tools on my server

one tool i want to build is a page that lists all the tables in my current database
(i dont have access installed on this machine either)
all the examples i have seen use dao
i am used to ado, but not dao

i will give these methods a try, but wanted to post this up here in case someone knows exactly how to do this

thanks

 

[vongrunt]

Try with ADOX, more precisely ADOX.Catalog object.

 

[DreXor]

there's links in this thread ( thread333-825356 ) on how to do this with sql, there should be reference information for Access as well


DreX
aKa - Robert

 

[DreXor]

may also want to google up "ASP MS Access Schema"

DreX
aKa - Robert

 

[dcmagain]

i did it like this:

set my_con = GetNLSCon()
set rs_tables = my_con.openSchema(20)

GetNLSCon is a function that returns connection object to the database i am using

20 is a value for the constant adSchemaTables

then i loop through to get the info
table_name gives you the table name
table_type will return SYSTEM_TABLE, TABLE(ones you made), or VIEW(queries)

 

[DreXor]

glad you got it patched up, hope the info helped


DreX
aKa - Robert