show field description

there is no provisions in ADO (what asp uses to talk to DB) to get that from the table

correction.. the code should be:

<% 
    Set c = Server.CreateObject("ADOX.Catalog")
    c.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\db1.mdb"
    d = c.Tables("table1").Columns("Field1").Properties("Description ").Value
    Response.Write "Description= " & d  
    Set c = nothing
%>

the space after description will stop it from working...

there is something wrong with this forums text box, it adds a space to the end of Description.. real weird.. sorry guys just remember to remove it after you copy the code.