Dan Waters
dwaters at usinternet.com
Wed Jul 30 18:41:41 CDT 2008
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