[AccessD] upsizing

Gustav Brock Gustav at cactus.dk
Thu Jul 31 03:44:15 CDT 2008


Hi Susan

There are several other "issues" with the update wizard. One I can think of is the addition of a timestamp field to each and every table. It doesn't hurt but I don't believe it should be needed in every case.

/gustav

>>> ssharkins at gmail.com 31-07-2008 00:45 >>>
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. 





More information about the AccessD mailing list