[AccessD] Closing an open file

Fred Hooper fahooper at trapo.com
Tue Nov 7 18:55:36 CST 2006


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




More information about the AccessD mailing list