Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why does WINNT think my table is still open exclusively?
Message
From
10/11/2001 02:08:54
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00579951
Message ID:
00580089
Views:
25
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform