Decipher Access MDB Reports and Forms with ADO?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Decipher Access MDB Reports and Forms with ADO?

  1. #1
    ken handzik Guest

    Decipher Access MDB Reports and Forms with ADO?


    I need a working example of how to use ADO to obtain a list of Reports and
    Forms from within an Access database.

    All of the examples I have found show how to list Tables and Columns, but
    don't deal with Objects that used to be
    easy to retrieve with DAO Container and Document collections.

    Since I am writing new code and should not use DAO (per MS support), is there
    something wrong with my question or what?

    The Help systems and online references seem to imply that Reports and Forms
    are Access Objects.

    Does that mean I should look for some vendor-specific Properties?

    The VB Object Browser and Watch window for an ADODB or ADOX object don't
    help much either since everything vendor-specific
    is dynamic now (i think).

    I know it all has to be in there somewhere, but where?

    Access Reports and Forms are what I need most, but I'm curious about how
    Macros, Modules and Pages are stored also.

    email me directly or answer here for all to see...

    Ken Handzik
    khandzik@att.net


  2. #2
    Paul Mc Guest

    Re: Decipher Access MDB Reports and Forms with ADO?


    G'day Ken.

    >I need a working example of how to use ADO to obtain a list of Reports and
    >Forms from within an Access database.


    Well... this not really a job for ADO. ADO is concerned, basically, only
    with data - ie tables & queries (views).

    ADO is not really comparable to DAO - DAO was so Jet-centric, it was specifically
    written for Access work. ADO is more like ODBC - it lets you get to data
    and that is it's entire role.

    To work with Access specific objects such as Forms, Reports, modules etc,
    you would be best off using the Access object model - just add it to your
    references and there you are - you have access to Access "8-)

    Cheers,
    Paul Mc




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center