Access 2003 Project with SQL Server Express 2005

• jwellington

  Ten Centuries

  Points: 1062

  More actions

  April 28, 2008 at 5:12 pm

  #189950

  Hi,

  I am using Access Project 2003 with SQL Server Express 2005.

  When I go to design a new view within Project I get the following message:

  'This version of Microsoft Access doen't support design changes with the version of Microsoft SQL Server your Access project is connected to. Your design changes will not be saved.'

  Is there something I need to do to get the full functionality between these two program versions?

  Thanks

• jmoss111-506838

  SSChasing Mays

  Points: 651

  More actions

  April 30, 2008 at 8:41 am

  #809086

  You'll have to design the view in SQL Server. Access 2003 can't build object in SQL Server 2005, just 2000

• m3jim

  SSC Rookie

  Points: 40

  More actions

  May 1, 2008 at 6:36 am

  #809497

  I've heard that Access 2007 can design against SQL 2005, but I haven't tried it.

  Jim

• jmoss111-506838

  SSChasing Mays

  Points: 651

  More actions

  May 1, 2008 at 8:28 am

  #809584

  I think that is correct. Actually you could build a sql view in access 2003 by using a pass through query not with the designer.