Hello
I already initiated a thread with the same name on 22/03/2004. Thank
you everyone who answered me.
I wanted to link to that thread, but somehow there was no "Post follow
on article" link(?). Sorry for repetition, but the story has developed
a bit.
We have an Access 2000 database application - reports distributor.
Reports are created by developers, then reports and queries are copied
into a database (Access 2000 also) on network. It is called
repmanobjects. The application's front-end is on PCs. When a user
selects a report to run, the report and everything it needs is copied
from repmanobjects.
When I initiated the previous thread, there was one table in
repmanobjects, which recorded each report's execution. Since then, I
removed this table into another database. As a result, the only thing
repmanobjects is used for is to copy reports and queries from it,
which is done by the following command:
DoCmd.TransferDatabase acImport, "Microsoft Access", serverDB,
acReport, stDocName, stDocName
We, developers, need to export reports and queries into repmanobjects.
Now (after I have removed the registration table) we can export
queries, - no problem, but not reports. Any idea, why? What is the
difference between reports and queries as objects? What direction
should I search to sort out this little problem? Because to come to
work earlier then anyone else started working to copy reports prepared
yesterday into repmanobjects is a bit unpleasant.
Any help will be greatly appreciated.
Galina