Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
File is in use by another user.
Message
From
03/12/2004 14:09:11
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
 
 
To
03/12/2004 10:03:39
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00966682
Message ID:
00966796
Views:
10
Sylvain,

It turns out that 1 PC had the table opened shared and was performing an APPEND FROM that took awhile. The other PC attempted to USE the file and that produced the "File is in use by another user." error.

Thanks for your help.

Jerry



>Can you put a breakmark before the USE and check your SET EXCLUSIVE setting? You could also try
USE mytable IN 0 SHARED
>
>>My error routine is currently trapping errors and it says that the following line is causing the "File is in use by another user.":
>> USE mytable IN 0
>>
>>I am trying to fix this but I can't reproduce the error "File is in use by another user.". I my testing I always get the "File Access Denied", assuming that the table is opened exclusively already.
>>
>>So far I have not been able to reproduce the "File is in use by another user." error.
Previous
Reply
Map
View

Click here to load this message in the networking platform