[AccessD] Closing an open file

Well, it's a bit complicated. I had to use macros instead of code and did
some OutputTo calls. I can't easily change the names. Plus, it may cause
some confusion with the illiterate computer users if they start seeing all
these reports. I know what you're thinking, but I pushed them way ahead so
far in computer literacy but they still have a ways to go.
Eventually, I'll be able to do it, but not now.

John


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
Sent: Tuesday, November 07, 2006 12:01 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Closing an open file

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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com