From: thegroup@microsoft.com   
      
   Hello all,   
      
   This is a newbie design question.  I have a table with the following fields   
      
   TABLE A   
   ID, Prop1, Prop2   
      
   I expect that I might have multiple concurrent users accessing the same   
   record (in a recordset via SELECT).  If I expect to have users modify either   
   Prop1 or (XOR) Prop2 I should also expect the DB to complain since one of   
   the users would have the record locked (I'm learning lots about locks).   
   Would that complaint be an ADO exception or would the locked out user just   
   wait for the record to be free?  Would a better design for this scenario be   
      
   TABLE A   
   ID, Prop1   
      
   TABLE B   
   ID, Prop2   
      
   this way the users would not interfere?   
      
   Thanks   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)