Re: Weird file in use problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Is this on a a real server OS or on XP acting as a server? (or worse yet
W98 as a server).

The connections in those cases are limited.

--
Fred
Microsoft Visual FoxPro MVP


"tristan" <tristan@xxxxxxxxxxxx> wrote in message
news:%23mk3k$hyFHA.3700@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> We have a VFP8 SP1 app which is running sitting on a network share, 22
> Windows XP users each access this application from this network share.
>
> This application has been running fine for the past 2 years and then all
> of a sudden (past 2 months randomly) users have started complaining they
> can't get access into some forms. They get 'File in use' error and it is
> always the one 'Members' table which gives the error.
>
> We have some debug information which writes out to a log what users have
> that "members" table open at the time the user gets the error.
>
> Now my understanding is that this error happens when the file is
> exclusively locked, correct? Our logging information shows that the
> Members table is open on multiple other workstations while this person is
> getting this error. So how can more than one person have it open and are
> not getting the "file in use" error. Where as this person is unable to
> open it.
>
> It is not always the same person that has the problem, so it is not
> machine related as far as we can tell. These forms open up other network
> tables too, and they never cause problem, so I don't believe it is network
> related. The server is not showing any errors for connectivity problems
> either.
>
> So random machines, random users, but always the same table.
>
> Any ideas what could be going on, its like the file can only be opened by
> 5 people and the 6th person who tries to open it is getting denied. Is
> there anything which could cause this behaviour?
>
> Thanks
> Tristan
>
>


.

Relevant Pages