[AccessD] A2003: Deleting Open Files on a Remote Computer

Hi Darren

But wouldn't the user have the VPN connections reestablished automatically when he/she logs in again?

Or you could make the files (or the folder(s) holding them) read-only for the users?

/gustav


>>> darren at activebilling.com.au 07-07-12 16:38 >>>
Hi Gustav,
Many thanks for the reply.
I'm not sure I can do that - As 'logging them out' will also kill their VPN
connection(s) to our systems (This is critical so they can run our
software).
But forcing them to drop a file or deleting the file is acceptable, as part
of a 'flush'.
When we do these 'flushes' we immediately fill the same folder with updated
versions of the same files (Same file names and everything).
But it's important they maintain their dB connectivity via our software and
the VPN though.
Any other suggestions :-)?
Many thanks in advance
D

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Friday, 6 July 2012 5:19 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] A2003: Deleting Open Files on a Remote Computer

Hi Darren

I think you will need to logout those users to release the files.
This can be done remotely as well.

/gustav


>>> darren at activebilling.com.au 06-07-12 4:51 >>>
Hi team,

We have a server that remote users have access to where they can see files.

Mostly XLS, PDF, XML and a few proprietary ones too.

And of course they can open and view these files.

We regularly fill (by writing to) and empty (by deleting) the file contents
of some of these folders.

>From time to time a client may have a PDF or XLS etc. DOC open when we need
to do one of these flushes.

We see this when we manually delete the contents of a folder there may be
one or 2 that can't be deleted.

And then off we go to the Computer Management snap in to find and manually
close the file. We then delete it from the folder.

Is there some way to delete all files in a folder and then go back and do a
(brute) forced delete on the ones that didn't delete on first round?

Or is there some better logic and methodology you blokes use?

Don't be bothered about filling and deleing files opened by another user,
it's a regular thing as we update files (with the same file name) many times
per month.

Many thanks in advance.

Darren.