RE: [AccessDevelopers] Record Lock on SQL

[Jim Jones]

Thanks! That was it. Your a geniusTom Oakes <[EMAIL PROTECTED]> wrote:          I've encountered the same thing - defining a bit column in a SQL table and not specifying a default causes headaches.  You should specify a default, but you also need to go back and flip the values in the existing records to true or false - they're apparently null by default.     You might to a bulk SQL update that sets your bit value to 0 where it is null.    Tom Oakes Personal PC Consultants, Inc. [EMAIL PROTECTED] 503.230.0911 (O) 402.578.2648 (C) 512.727.9497 (F)       From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Lava BoggavarapuSent: Friday, January 20, 2006 7:01 AMTo: AccessDevelopers@yahoogroups.comSubject: RE: [AccessDevelopers] Record Lock on SQL      Do you have any fields connected to a bit type columns in the DB?     I encountered this problem long ago and the culprit was the bit type column. If you do have one, try setting a default value to it.     -----Original Message-----From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of
 accessriderSent: Friday, January 20, 2006 9:56 AMTo: AccessDevelopers@yahoogroups.comSubject: [AccessDevelopers] Record Lock on SQL     I am connected to a SQL backend. I can add a record just fine but if I try to delete it or modify it, I get an error that msjet has stopped the process because you an another user are attempting to change the same data at the same time. This is not true. Anyone have any ideals? ThanksRiderThe information contained in this message and any attachments (the "Message") is intended for specific individual(s), and may be confidential or proprietary. If you are not the intended recipient, please notify the sender immediately, delete this Message and do not disclose. Messages are not secure or error free and can contain viruses and the sender is not liable for any of these occurrences. The sender reserves the right to monitor, record and retain Messages.  
		Do you Yahoo!? 
With a free 1 GB, there's more in store with Yahoo! Mail.






Please zip all files prior to uploading to Files section.





  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "AccessDevelopers" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.