[AccessD] Closing an open file

Thanks Fred! I really appreciate it.

John

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

Hi John,

I'd forgotten how messy it is to use; very flexible but it can be tedious.

The general process is (1) Run one of the PsTools to find out who has the
file open, (2) place a batch file on the server that the file you want to
close is on (actually, you're breaking the link to the open file -- it's
still "open" on the user's pc), (3) place a batch file on your pc that will
execute the batch file on the server using one of the PsTools, and (4) If
you're polite you notify the user that the link has been broken. For most of
these steps you should check that they were successful.

I used it in a VB program for copying Cognos cubes (for which dropping a
direct user is a subset of the issues). I'm sending a copy to you off list
as it's too big to attach. Look particularly at the "Copy Locked Cube"
section.

Fred

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Skolits
Sent: Tuesday, November 07, 2006 11:52 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Closing an open file

Drew,

I'm looking at sysinternals.com like Fred Hooper suggested. Still trying to
figure out how to use it, especially through VBA. 

If it doesn't work out, I'll go down your suggested road.

John

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