ADOX and ASP

[ai3rules]

Hi all,

I've been trying to find some detailed information on how to use ADOX. So far I've created the adox.catalog object and iterated through all the tables.

It looks like there is much more information I can get using this method such as RelatedTables and field specific info etc. I just can't seem to figure it out.

The information from Microsoft on this is quite unhelpful - to me at least.

Does anyone know of a better resource which might include examples of ADOX for ASP?

I appreciate any help...

[so_is_this]

MS created ADOX, so if you don't like the MS documentation, I don't think you'll find better elsewhere. I, myself, used only the following link (and follow-on pages) to create an entire application which not only displays the entire structure of MS Access and MS SQL Server databases but also creates either of those databases, tables, and indexes.

MS ADO & ADOX Reference (http://msdn.microsoft.com/library/en-us/ado270/htm/mdmscmicrosoftadoprogrammersreference.asp)

Though, for MS SQL Server tables (IIRC), I think I did switch from using ADOX to just using SQL statements to create tables and indexes.