OutputTo with Remote Database

  • Thread starter Thread starter J Nap
  • Start date Start date
J

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.
 
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)",""
 
Back
Top