Post reply

Access 2003 Project with SQL Server Express 2005

  • 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

  • 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

  • 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

  • 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.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply