> I'm looking for a way to detect if another process has a file open before
a

Make certain you know it exists, then,
Try to open the file exclusively,
an error means it is in use.
Good day,
Roger

"Roger" <(E-Mail Removed)> wrote:

>> I'm looking for a way to detect if another process has a file open
>> before a
>
> Make certain you know it exists, then,
> Try to open the file exclusively,
> an error means it is in use.

I'm not proposing a better solution, but I'm pretty sure using error-
trapping or exception handling to test for a thoroughly possible condition
like this would not qualify as a "best practice"...

--
Michael Kellogg

I'm looking for a way to detect if another process has a file open before a
second process tries to open it. I've looked into the FileAttr function but
I'm not sure if detecting a read-only state is sufficient. Can anyone
confirm or deny? TIA...

Glen,

This is endless asked, however this is as long as there are the MS-dos
operating systems and its successors not possible when you don't create a
special management tool around it, as probably in Office is done.

Cor

glen,

Answers on this are

do while loop condition = false
Try
Open a file
When found leave set the condition to true
Catch
threading.thread.sleep(1000)
'And set a max if you want
End

I hope this helps something

Cor

I have to agree. I'm thinking there must be a way to test the state of the
file for this condition. I just haven't found anything yet...

"Michael Kellogg" <(E-Mail Removed)> wrote in message
news:Xns96228D5919534mkelloggWEDELIVERcc3@207.46.248.16...
> "Roger" <(E-Mail Removed)> wrote:
>
>>> I'm looking for a way to detect if another process has a file open
>>> before a
>>
>> Make certain you know it exists, then,
>> Try to open the file exclusively,
>> an error means it is in use.
>
> I'm not proposing a better solution, but I'm pretty sure using error-
> trapping or exception handling to test for a thoroughly possible condition
> like this would not qualify as a "best practice"...
>
> --
> Michael Kellogg

It's 'The eternal question', then...

"Cor Ligthert" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Glen,
>
> This is endless asked, however this is as long as there are the MS-dos
> operating systems and its successors not possible when you don't create a
> special management tool around it, as probably in Office is done.
>
> Cor
>

Interesting....I'll try that. Thanks.

"Cor Ligthert" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> glen,
>
> Answers on this are
>
> do while loop condition = false
> Try
> Open a file
> When found leave set the condition to true
> Catch
> threading.thread.sleep(1000)
> 'And set a max if you want
> End
>
> I hope this helps something
>
> Cor
>