Using OutputTo to generate report output by overwriting existing file

Using OutputTo to generate report output by overwriting existing file

Post by mhath » Tue, 17 Jun 2008 22:15:32


Hello,

I am a complete Access newbie so apologies if this is a rather trivial
problem.

I have to upgrade an Access 2003 database to Access 2007. This mdb has
a Report that's being exported to .snp file. The requirement is to
convert the report output to a pdf and so I thought using a macro
action of OutputTo with Output format set to pdf.

This method of exporting to pdf works rather well.

Now, our users want to setup this report export at scheduled intervals
with the pdf file being output to a shared network location accessible
to select group of users.

I experimented with the method of using the /x switch to execute a
named macro from the command line (batch file) and it seems to
work...except that the OutputTo pdf step in the macro prompts whether
to overwrite the file because already exists (from a previous run).

This is a major problem and I think there must be a workable solution
used by other companies, developers in the Access diaspora.

Is there a switch or an option to force OutputTo to overwrite existing
files? I tried the SetWarnings to No but that does not work.

Thanks,

Manish