IF someone has difficulties using the Upsizeing Wizard of Access03 (or 07), look into the Sql Server Migration Assistant (SSMA) for Access. This does a much better job, and...

Members of the Access team and MVPs have adivised me to avoid ADP (and ADO) unless required because: MDB and DAO is a richer function set, it provides more flexibilty,...

you are better off using the SSMA [for Access] wizard , rather than the Upsizing Wizard embedded in ACCESS. Search microsoft.com for SSMA.

The reason to use SSMA is that...

You could change the data type in the table and limit to 1 or 0, but then you couldn't use the check box.

However, you can build baseline queries...

It appears that you are trying to write this into the sql data file [.mdf]directly. If so, that is impossible. If I am wrong about that, digg this...

I see you listed your 'current' sql as '2005 ... 8.xxx SP3'. This is incoherent as sql2000 was version 8.xx and it has a SP3 while sql2005 is version...