Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table locks up over network
Message
 
To
10/03/2000 14:14:37
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00344344
Message ID:
00344527
Views:
26
Tyler, are you using buffering? It sounds as if you have buffering off and the record is being locked by the first user to access it.

With buffering, users look at/edit copies of the data. Then when a TableUpdate() or TableRevert() is issued (usually in the Save and Cancel buttons) the main data tables are updated.

Barbara

>I have a form that I use to access the contact table of my database. When two users are on the same record the user that scrolled to that record last the table locks up until the first user goes to another record. The second user can't do anything until the first is off. The same happens when they go to enter a record each. If they do it at the same time. The second one has too wait for the first user to finish before he can enter his data.
>
>I have set exclusive off so I don't know why it would be doing this. Any ideas would be appreciated. Thanks.
>
>Tyler
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform