table locking 
Author Message
 table locking

I need to figure out how to lock tables for my client server application.  I'm
using VB4 16bit and DB2/2.  I need to lock tables when the user enters an edit
mode.  While I haven't executed any sql, once a user enters an edit mode, I
have to ensure that nothing changes the table that the user wants to edit until
edit mode is exited.  

I also need to know how I can lock the table so that others can continue to
read the table as well as locking the table so that other do not have read or
write access to the tables.

I've also noticed that at times when other methods are locking the tables, vb
waits for the table locks to free up, while not returning an error code saying
that the table is locked at this time.  Is there any way to force VB to return
an error if a table is locked rather than waiting for the table to unlock?

Sun, 30 Aug 1998 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. open Access table = locked Access table??

2. open Access table = locked Access table??

3. Drop table error - table locked

4. open Access table = locked Access table??

5. Table locking problem

6. atomic promote/demote Access table lock?

7. Question re: Table locking - exclusive

8. Functions and table locks

9. Table locking problems

10. Exclusive table locking

11. Table locking in ADO

12. Tables locked in multiuser environment


Powered by phpBB® Forum Software