Hi all



We've written an application in ASP, which is currently using access as 

its backend. 

I would like to take an existing MDB and create the sql code that can be 

used to create all the tables and relationships.

ie strsql="Create table vehicles (vid char(10)); "

etc etc



In Visual Foxpro I have a function called gendbc which reads the database 

and writes out the sql code to create that database.



Is there anything in access/asp/ado to do the same?

I don't want to reinvent the wheel if it already exists.



Any ideas?



Regards

Graham