sql bit fields

[mcourter]

anybody know how to how to allow null bit fields when using tables
linked to ms sql backend? i set the tables to allow nulls on the sql
side and have to use default value of 0 before i can update records on
the access side. in many cases the users don't want a default value
because it can indicate a strong "No" value when actually null is more
appropriate.
please only respond will a direct solution (if there is one). changing
data type is not an option.
thanks,
mcnewsxp

 

[Kevin3NF]

From Books Online:

bit
Integer data type 1, 0, or NULL.



But in my experience, I have always had to set a default AND make sure all
nulls were populated with either 1 or 0 in order to get the Access FE
working


--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions

 

[mcourter]

that's what i've always done.
i need to know if there is another way other than just using a smallint
field.
thanks.