[AccessD] An interesting "feature" in SQL Server

Anita,

Do you happen to a have a link to that microsoft patch or at least any
articles at microsoft talking about the issue? 



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Anita Smith
Sent: Wednesday, May 20, 2009 7:51 PM
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
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

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