Microsoft KB Archive/88231

{| = PRB: Cannot Select or Edit Record from Shared Database =
 * width="100%"|

ID: Q88231

The information in this article applies to:


 * Microsoft FoxPro for MS-DOS, version 2.0

SYMPTOMS
The records displayed in a pop-up window in a shared database cannot be highlighted or edited.

CAUSE
The most likely cause of this problem is that the record in the pop-up window is locked by another user. Once FoxPro locks a record for one user, it cannot lock the same record for another user until the first lock has been released.

RESOLUTION
In an application, incorporate a routine that attempts to lock the record and informs the user when the record is already locked. Each record can be locked by only one user at a time. For more details, see the &quot;Multiuser Programming&quot; section of the FoxPro &quot;Developer's Guide.&quot;

MORE INFORMATION
Testing the pop-up window with memory variables produces the desired results. However, a memory variable behaves in the same manner as a record in a stand-alone database. In this setting, sharing records between users is not an issue because neither the records of a stand-alone database nor the memory variables can be shared among users across a network.

Additional reference words: FoxDos 2.00 FLOCK LOCK RLOCK SET REPROCESS KBCategory: kbprg kbprb KBSubcategory:
 * }