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,...
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...