Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
File Locking Problem
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00517658
Message ID:
00517660
Views:
14
>Dear all,
>
>Do you have same problem in your application? I have an application and run on our LAN environment. I just shared the application directory for user. When User A append a record using APPEND BLANK command, User B also want to append a record at the same time. At that time an message showed on the status bar at User B's computer "Attemping to lock the record, press Esc to cancel". But User A has released/finished the record and repeat the process again, User B still wait to lock the record for a long time. I have already set the "REPROCESS" to 5 seconds. The problem still occurred. Anyone has idea to solve that problem? Thanks a lot!!
>
>Best Regards,
>
>Justy Chow

Justy, check the following :

  • An Unlock was done at user A after Rlock() ?
  • User A didn't use Flock() ?
  • Is MultiLocks Off ?
  • Does the (Novell) server provide for sufficient lock space (per user and global) ? (Set Maximum Record Locks = )
  • if applicable, did user A perform TableUpdate ?

    The above per topic necessarily won't solve the problem, but looking at the combination of things may.
    Anyway, HTH,
  • Previous
    Reply
    Map
    View

    Click here to load this message in the networking platform