Anyone have a solution to the boolean datatype problem
where SQL 2000 changes the way that bit datatypes are
evaluated? When I try to use a checkbox control in Access
2000 to change the data in this field, the control works
greate with false values (0), but does not work with true
values(-1 or 1).

Hope some has figured this out!!!

Yes, this is a known problem. See the following:
http://support.microsoft.com/default...b;EN-US;280730

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446

On Mon, 3 Nov 2003 16:50:33 -0800, "Jerry"
<palladino@pinewaysoftware.com> wrote:

>Anyone have a solution to the boolean datatype problem
>where SQL 2000 changes the way that bit datatypes are
>evaluated? When I try to use a checkbox control in Access
>2000 to change the data in this field, the control works
>greate with false values (0), but does not work with true
>values(-1 or 1).
>
>Hope some has figured this out!!!