Results 1 to 2 of 2
  1. #1
    joethall is offline Novice
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Posts
    9

    Question How to access the description attribute

    Each field of an Access DB has several what I will call "attributes". Like Field Name, Data Type and Description. Once a DB has been created and is access from a web server, how can the contents of the Description attribute be read?

    I can open the .mdb file with:
    ...
    Set oConn = Server.CreateObject("ADODB.Connection")
    oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filePath
    mySQL = "SELECT * FROM tblSchools"
    oRs.Open mySQL, oConn, adOpenStatic, adLockOptimistic
    For Each F in oRs.Fields
    %><%=F.Name%>&nbsp;<br>{need descripton here}<%
    Next
    ...
    Thoughts?
    Joe

  2. #2
    joethall is offline Novice
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Posts
    9

    More on the problem

    I tried:
    <%=F.Name%>&nbsp;<%=F.Properties("Description")%>< br><%
    but it fails

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 05-05-2010, 04:31 PM
  2. Query A part description /name
    By wvswede in forum Queries
    Replies: 5
    Last Post: 04-07-2010, 06:07 AM
  3. Unnhide Attribute?
    By thorsonb in forum Access
    Replies: 1
    Last Post: 03-30-2010, 10:21 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums