Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2004
    Location
    Oxfordshire, UK
    Posts
    89

    Unanswered: DAO to ADOX Conversion Problems

    Hi All,

    Does anybody know how to access the Currentdb.Containers("Databases").Documents:
    1 AccessLayout
    2 SummaryInfo
    3 UserDefined

    by using ADOX? Any help would be appreciated. Ta.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    There are all collections, so you can iterate through the collection by using the for each construct. Some a re collections of collections, some are collections of properties.

    If you examine the items in the the colections you will find what you want

  3. #3
    Join Date
    Oct 2004
    Location
    Oxfordshire, UK
    Posts
    89
    Fair enough, but how do you get to the ADOX equivalents from say CurrentProject or another ADOX object?

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi

    I'm afraid I still use DAO for my DDL object type stuff but below look like they more or less answer your question:

    http://msdn.microsoft.com/library/de...bjectmodel.asp

    http://msdn.microsoft.com/library/de...ollections.asp

    http://msdn.microsoft.com/library/de...adcolviews.asp
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by MyNewFlavour
    Hi All,

    Does anybody know how to access the Currentdb.Containers("Databases").Documents:
    1 AccessLayout
    2 SummaryInfo
    3 UserDefined

    by using ADOX? Any help would be appreciated. Ta.
    oops - reread your specific requirement - if it is, it will be in those links. Doubt it though - they sound a wee bit proprietry to Access. What are they? Is it information you could dig out of the system tables?
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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