Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
It's feasible under multi user environment?
Message
From
25/04/2002 08:55:04
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
25/04/2002 08:49:50
Michale Chen
Shijiazhuang ZhiYuan Crop.
Shijiazhuang, China
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00649067
Message ID:
00649093
Views:
15
>Hi Hilmar:
>Thanks for you help.
>In fact I need multi user use this kind command access the shared .dbf files,is it possible?

You can access a DBF on a shared folder just as you can on your local disk. Some considerations apply...

  • You can directly access a shared folder like \\MyServer\MyApp. Make sure this path contains no spaces!
  • You have to open files shared. See: USE ... SHARED, or SET EXCLUSIVE OFF. SET EXCLUSIVE OFF is simpler, since you have to give the command only once - it applies to all DBFs opened later.
  • If you need exclusive access to some table (for commands like INDEX, PACK and others), you have to throw out all your users (or the ones that use the specified table), and then USE ... EXCLUSIVE.

    HTH, Hilmar.
    Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
  • Previous
    Next
    Reply
    Map
    View

    Click here to load this message in the networking platform