Overview: Excel (from Office 2003) is having issues maintaining file locks when saving documents to a windows 2003 server share while someone else opens.
If the user (who has the file locked) isn’t currently saving, then the other person trying to open the same file gets the standard excel message that a “User has the file locked” (this is correct)
But if someone is opening the file while someone else has it locked and is saving at the same time its being opened, then they can loose the file lock and then have to save changes in an alternate file.
How to replicate (to force the issue)
1) User A Opens file “X” for Read/write in excel
2) User A, continually clicks on the save icon in excel
3) User B attempts to continually open file “X”, until they get write access (if receive file lock message, then close and try again)
4) User A has now lost lock on file, and Excel will eventually report a save failure, requiring user to save to an alternate location
I’ve done some digging, and thinking it might be related to preemptive locking on the Windows 2003 server (Before, there was a windows 2000 pro machine acting as the source server for file “X”, and this issue wasn’t present as far as I can tell)
Anyone else experienced this? Any luck on a solution
Thanks
Paul