I have a report template that saves a report twice; a 'DatedReport 20070227'
and a 'LastReport'. I created a 'LastDate' table in the LastReport report
that is refered to in the template (it is in a small data query). So when
the template runs it updates the datatable linked to the LastReport.LastDate,
but now I want to save the report.

The file will save as DatedReport 20070227 just fine, but it will not allow
me to overwrite the LastReport saying #70: Access Denied.

I think the link from the tempolate to the LastReport is still open.
Q- How do I close the connection to the LastReport so I can overwrite the
file?

Thanks so much for you help.

I found the answer using :
Sheets("Corrective Action Record").QueryTables("Latest_Report").Delete

"Candyman" wrote:

> I have a report template that saves a report twice; a 'DatedReport 20070227'
> and a 'LastReport'. I created a 'LastDate' table in the LastReport report
> that is refered to in the template (it is in a small data query). So when
> the template runs it updates the datatable linked to the LastReport.LastDate,
> but now I want to save the report.
>
> The file will save as DatedReport 20070227 just fine, but it will not allow
> me to overwrite the LastReport saying #70: Access Denied.
>
> I think the link from the tempolate to the LastReport is still open.
> Q- How do I close the connection to the LastReport so I can overwrite the
> file?
>
> Thanks so much for you help.