Question
January 23, 2008 at 01:31 PM
k7aay

Microsoft Access 2003: How to delete files in MyDocuments?

by k7aay . Updated 18 years, 10 months ago

The OutputTo macro command outputs files into the MyDocuments folder, and I have a process which needs to do that periodically… but if there are leftover files from the last time that was run, my user gets hit with a dozen requests to overwrite the preceding files. I’d like to delete those from within the Microsoft Access 2003 macro which creates the reports, but I don’t see how to do that.

Alternatively, if I could send the files to a specific directory (e.g., C:\TEMP), I know how to delete files there; is there a way to direct the OutputTo command to send the files it creates to C:\TEMP?

Thank you kindly.

This discussion is locked

All Comments