[AccessD] An interesting "feature" in SQL Server

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
>>



More information about the AccessD mailing list