jwcolby
jwcolby at colbyconsulting.com
Thu May 21 10:01:06 CDT 2009
What do you use? Int? John W. Colby www.ColbyConsulting.com Anita Smith wrote: > John, > I have stopped using bit fields as they play up on Access continous forms > when using tick boxes. Microsoft has a patch but it doesn't always fix the > problem. > Anita > On Thu, May 21, 2009 at 8:29 AM, jwcolby <jwcolby at colbyconsulting.com>wrote: > >> I am starting work on a database at an old client that was converted to SQL >> Server. I discovered >> that if I enter records into a table that contains a bit field, and that >> bit field is allowed to >> store a null value, then any time I try to edit any field in that record >> (at least through ODBC) I >> get a "you have attempted to update a record being edited by another user" >> kind of error message and >> the update fails. I had to go into Management studio and set the bit to >> either a zero or a -1 at >> which point the edits work normally after that. >> >> Loverly. >> >> -- >> John W. Colby >> www.ColbyConsulting.com <http://www.colbyconsulting.com/> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >>