We have had the same problems after changing
from MSSQL2000 to MSSQL2005.
The complete Development Mode for Queries/Views in our Access2003.adp is locked and must be done with the new
Enterprise-Manager direkt in SQL-Server 2005.
Unfortunately we are missing the sort of all Views
because orderby in a View is not supported in MSSQL2005