ADOX - how do u find a required Access field progr

Results 1 to 3 of 3

Thread: ADOX - how do u find a required Access field progr

  1. #1
    Josh Patterson Guest

    Default ADOX - how do u find a required Access field progr

    ADOX - how do u find a required Access field programmatically?<BR>In what collection/method is this attribute/property contained? It is in every Access DB, but I can&#039t expose it to ASP and ADO/ADOX. Any ideas?

  2. #2
    Join Date
    Dec 1969
    Posts
    89

    Default RE: ADOX - how do u find a required Access field p

    I assume that you have an application level connection object called Application("DB") that has connected to the database.<BR><BR>Sub FindFields()<BR> Dim TB<BR> Dim i<BR> set TB=Application("DB").execute("Select * from SomeTable")<BR> for i = 0 to TB.Fields.Count -1<BR> response.write(Tb.Fields(i).Name & "<BR>")<BR> Next<BR>End Sub<BR><BR>that&#039s it you now have all the fields in the table...do anything with these...happy programming.

  3. #3
    Josh Patterson Guest

    Default RE: ADOX - you misunderstood.....

    No, I mean, In Access, certain fields have to contain a value before the record can be initialized. They have the &#039required&#039 flag set to &#039yes&#039 or &#039true&#039; How do you, programmatically, find this in ASP/ADO/ADOX?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •