OutputTo with Remote Database

[J Nap]

My goal is from one Access database to make a connection
to another Access database and enumerate through that
databases report objects and export them to a snapshot
format (*.snp)

I am making a connection from one Access database to
another and am enumerating through the report objects.
I would now like to be able to use the OutputTo method
against each report in the remote database.

From the current database I am using:
Docmd.OutputTo acReport,rptName, "SnapshotFormat(*.snp)",""

How do I specfify that the rptName referenced is in the
remote database. Online help says to use a "library
database" but I am not sure what they are referring to.

Thanks.

 

[Alex Dybenko]

You can open one more instance of access using
set oAccess=CreateObject("Access.Application"),

then open other DB there
and export reports then:

oAccess.Docmd.OutputTo acReport,rptName, "SnapshotFormat(*.snp)",""