[AccessD] An interesting "feature" in SQL Server

I always set them to 0 too, but I have a case in an Access 2003 adp where
the check box is getting checked as soon I start entering data in another
field for a new record.  I was hoping Anita had a link to the Microsoft fix
that I could look at.


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hewson, Jim 
Sent: Wednesday, May 20, 2009 10:42 PM
To: Access Developers discussion and problem solving
Subject: Re: [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.

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

**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************