The MS Access Team Blog has today posted this advice:
- Access 2007 ADP’s will run against SQL Server 2008 but do not support designing server objects (tables, views, stored procedures, functions and relationships).
- SQL Server 2008 shipped after Office 2007 SP1 and after MS had locked down all the fixes for Office 2007 SP2 (coming out in a few months).
- If you rely on the design features of ADP’s it is recommended that you stick with SQL Server 2005.
- If you do make the move to SQL Server 2008 use the SQL Server Management Studio to design your server objects.