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...
Re: 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.
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-)
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL