[AccessD] An interesting "feature" in SQL Server

When I use bit fields with Access I make the default 0 and then I don't have to worry about it.
I deal with the 0 which makes it easy to control.
Jim

________________________________

From: accessd-bounces at databaseadvisors.com on behalf of Anita Smith
Sent: Wed 5/20/2009 19:50
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] An interesting "feature" in SQL Server



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 <http://www.databaseadvisors.com/> 
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/> 



################################################################################
If you have received this message in error, please contact the sender
immediately and be aware that the use, copying, or dissemination of 
this information is prohibited. This email transmission contains 
information from NCI Information Systems, Inc. that may be considered 
privileged or confidential and is intended solely for the named 
recipient.
################################################################################

################################################################################

NCI is a company dedicated to trust, integrity, and performance.

If you have received this message in error, please contact the sender
immediately and be aware that the use, copying, or dissemination of 
this information is prohibited. This email transmission contains 
information from NCI Information Systems, Inc. that may be considered 
privileged or confidential and is intended solely for the named 
recipient.

################################################################################