[AccessD] upsizing

Susan Harkins ssharkins at gmail.com
Wed Jul 30 18:49:10 CDT 2008


Interesting... I'll keep looking! That's an interesting difference.

Susan H.


> Hi Susan,
>
> In the database I just converted this afternoon using SSMA, Yes/No values
> were converted to bits, and Allow Nulls is checked true.
>
> My SSMA version is 1.2.852, which is the latest version for Access 2003 
> and
> SQL Server 2005.
>
> Dan
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
> Sent: Wednesday, July 30, 2008 5:46 PM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] upsizing
>
> 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
>
> -- 
> 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