view database question

[Gonzosez]

I have an access 2000 database which I use for my asp application.
Is there a way to get a list of all the tables and table colunms via asp?
Thanks

[Ray at]

This is one way:


Set oADO = CreateObject("ADODB.Connection")
oADO.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=D:\path\to\database.mdb;"

Set oADOX = Server.CreateObject("ADOX.Catalog")
oADOX.ActiveConnection = oADO

For Each oTable in oADOX.Tables
If oTable.Type = "TABLE" Then
Response.Write "<strong>" & oTable.Name & "</strong><BR>"
For Each oCol in oADOX.Tables(oTable.Name).Columns
Response.Write oCol.Name & "<br>"
Next
Response.Write "<hr>"
End If
Next

Ray at work




"Gonzosez" <tbyam@hinklemfgNS.com> wrote in message
news:Otxjc5H$DHA.2512@TK2MSFTNGP11.phx.gbl...

> I have an access 2000 database which I use for my asp application.
> Is there a way to get a list of all the tables and table colunms via asp?
> Thanks
>
>

[Aaron Bertrand [MVP]]

[url]http://www.aspfaq.com/search.asp?q=schema:[/url]

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




"Gonzosez" <tbyam@hinklemfgNS.com> wrote in message
news:Otxjc5H$DHA.2512@TK2MSFTNGP11.phx.gbl...

> I have an access 2000 database which I use for my asp application.
> Is there a way to get a list of all the tables and table colunms via asp?
> Thanks
>
>

[Bullschmidt]

aspAccessEditor
[url]http://www.aspit.net/applications.asp?action=aspaccesseditor[/url]

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Evertjan.]

Bullschmidt wrote on 02 mrt 2004 in microsoft.public.inetserver.asp.db:

> aspAccessEditor
> [url]http://www.aspit.net/applications.asp?action=aspaccesseditor[/url]
>

not there, Paul.

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)