record and table locking 
Author Message
 record and table locking

anyone have suggestions on the best way to lock tables and records for a
networked environment.  my problem is that i have two tables that users edit
mainly, table1 and table2.  unfortunately, the only way i have been able to
prevent corrupted tables is to explicitly lock the tables whenever a user
edits any part of the table.  this is inconvenient for the other others.  i
would like to lock the record if the user is editing the record, and lock the
table if the user is inserting or deleting a record from the table.  is this a
good idea? or will it still cause corrupted tables?  maybe someone has a
better idea.....


Sun, 28 Dec 1997 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. SQL7 server crawls (locks) when deleting records from a 3 million record table

2. Record Locking - Is there a way to test to see if a record has been locked

3. Table is locked, workstation coughs, table stays locked.

4. Record locking bc of linked tables

5. Locking and unlocking table records...

6. User check if an record from a table is locked by other user ar run time

7. Access Table locked when no record return from SQL

8. Too many record locks on this table

9. SQL database table / record locking

10. Record Locking/Table Update problems

11. Record Locking/DBase IV Tables

12. BDE and Record/Table Locking

Powered by phpBB® Forum Software