Susan Harkins
ssharkins at gmail.com
Wed Jul 30 18:48:10 CDT 2008
oooooooooooooo.... I like that. :) Susan H. > 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 > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com