[AccessD] upsizing

Stuart McLachlan stuart at lexacorp.com.pg
Wed Jul 30 18:40:24 CDT 2008


Possiby because Access uses -1  for True and you can't represent that with 
a bit?

What value does SSMA store insert a True record (1 or -1)?


On 30 Jul 2008 at 18:45, Susan Harkins wrote:

> SSMA converts Access Yes/No fields to tinyint, instead of bit -- does anyone 
> have an explanation for that?
> 
> My guess is it's because SQL Server's bit didn't support NULL's until 7.0, 
> but it seems like the wizard would keep up with something like that. I 
> really can't recall if Access' Yes/No always supported NULLs or not.
> 
> Susan H. 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com





More information about the AccessD mailing list