>I just started working with a new client and ran across something that I can't figure out. Here's the scenario: I'm running VFP 6.0 SP3 (the developer's version, not a compiled vfp app) on a Windows 98 machine connected to a network served by WINNT 4.0 I issue the following set of commands from the command window:
>
>USE sometable EXCLUSIVE
>SELECT sometable
>INDEX ON somefield TAG sometag
>
>USE IN sometable
>
>* then, for good measure, after experiencing the problem a few times ...
>
>CLOSE ALL
>QUIT
>
>At this point, you'd think that the WINNT 4.0 server would see that this table is no longer opened exclusively, right?
>
>Unfortunately, when users attempt to access that same table through their VFP-compiled app (which, by the way was compiled on the same machine where I'm opening the table), they get a File Access Denied message. And when you look at the open files list on the server, it says that I still have the table open.
>
>Not until I log out of the network does WINNT indicate that the .dbf is available for shared access.
Is there any antivirus product running on the server?
Is there any AV, 3rd-party disk cache or other system utilities running on the W98 WS? If so, disable and see if the problem persists. (basically, make your environment as "clean" as possible)
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up