
Copy ACCESS Queries and Reports using VB6
The queries are in the QueryDefs collection and are directly accessible. The
Reports are not database components ... they are part of Access the application.
You can probably copy them if you create application references, eg by using
CreateObject().
Quote:
> We can successfully copy TABLES from one ACCESS database
> to another, using VB6 (SQL, Recordsets, ALTER TABLE etc to
> create new fields.)
> BUT how do we copy QUERIES and REPORTS from one ACCESS
> database to another ???
> Thanks in anticipation