I am Group Leader of the Adelaide Dot Net Users Group http://www.adnug.com based In Adelaide South Australia.
One of our members, Steve Koop, has created a tool "2SQL" that does 80-90% of the migration of Access to SQL Server.
The current Wizards and SSMA only do 10% as they only migrate tables, whereas prize-winning 2SQL processes forms, queries, modules, VBA. as well..
Steve gave a presentation on the Access/SQL migration problem at Microsoft TechEd2006 in Sydney last August. If members would like the slides and notes (500K) for an in depth analysis of scope of a migration project, please email me at secretary@adnug.com. for a copy.
.As Group Leader I like to promote the achievements of our members. 2SQL is an exceptional product.
PG