If you have a fairly complex web of forms with functions going on all over the place, can the upsizing wizard redirect all the queries and control sources?

Is it possible to continue using the same VBA front end with a database that's been migrated to SQL Server?

The short anwser is no, the best way to upsize is to just upsize the tables and then begin a step by step migration of the queries and functions.

I've just completed a major upgrade for one of my clients, a linked Access mdb front end onto a SQL Server 2005 back end and it works great.