Wednesday, January 21, 2009

ADP Developers: Stick With SQL Server 2005

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.