MartyConnelly
martyconnelly at shaw.ca
Tue Nov 7 11:00:59 CST 2006
If you don't care about removing the report, why not just time stamp the report file name, it also gives a unique name. "C:\temp\MyBigReport - " & Format(Now, "yyyymmddhhmmss") & ".rpt" John Skolits wrote: >When running Access, I create reports every night, but inevitably, some user >has opened the file off the network and never closed it. I can't remove it >with KILL. >Any one have code for closing a file that may be open so I can then delete >it? > >John > > > > -- Marty Connelly Victoria, B.C. Canada