[AccessD] Closing an open file

If the file has been opened from another computer (i.e. not the one that the
file is on), sysinternals.com has tools for identifying and closing the
link. What you want is PsTools, which is on their File and Disk list. I've
used it in the past for the same purpose.

Fred Hooper

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Skolits
Sent: Monday, November 06, 2006 12:33 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Closing an open file

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


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