Re: Unable to open Excel file in read-only if file already open by another user
- From: "Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom>
- Date: Fri, 11 Nov 2005 13:32:39 -0000
> Any suggestions how to get around this problem?
None. If Excel is opening these in a exclusive mode (and there is no reason
why it should not), you are stuffed. For certain Excel will have temporary
copy of the file so that if the user chooses to abandon changes, the
original file is kept.
You are going to have
(i) poll the files, see if one is free and keep your total ADO connection
time to a minimum
(ii) arrange for the other department to close files when finished with
them.
Stephen Howe
.
- References:
- Prev by Date: Re: Microsoft Access and Transaction Isolation Level
- Next by Date: Re: Bulk copy question
- Previous by thread: Unable to open Excel file in read-only if file already open by another user
- Index(es):
Relevant Pages
|
|
