get field type??

fandt det selv herinde:

Function Tabeldesign(base,tabel)
    Set conn = Server.CreateObject(\"ADODB.Connection\")
    Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & base
    set rs = Conn.Execute(\"Select * from \" & tabel)
    For each head IN rs.Fields
    tmp = tmp & \"<b>Felt navn: </b>\" & head.name & \"<BR>\" & \"<b>Felt Type: </b>\" & head.type & \"<BR>\" & \"<b>Felt Attributes: </B>\" & head.attributes & \"<BR>\"
    Next
    tabeldesign = tmp
    conn.Close
    Set conn = nothing
End Function

d

Prøv at downloade ASPadmin herfra http://www.netsrac.dk/netsrac-dk/