Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old February 22nd, 2007, 11:54 AM
Registered User
Join Date: Feb 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Ms Access 2003 and SQL 2005


I'm working with Access 2003 (adp project) and connect to my SQL server 2005 correctly; I can access tables etc

If I try to create or edit a stored procedure I have a message (I'm using a french version of Access) that I can translate more or less to:
"This version of MS Access can't save the changes make to this version of MS SQL to which your Access project is connected. Please go to the Microsoft Office update website to get the latest informations and downloads. Your modifications will not be save"

In the case I want to create a new sp, once I click ok I get a second warning (that I can translate as):

"You are contected to a newer version of SQL server than SQL 2000. This version of Visual Studio or Access was marketed prior to the version of SQL server you are connected. That's why some problems can occur. Ask MS if there is a service pack available for Visula studio or Office. You can continue but the new objects won't be enumerate and it will not be possible to save the object or diagrams made with Visual Databas Tools"

Anyone knows what I need to update and where to get it.

Old March 22nd, 2007, 02:50 PM
Authorized User
Join Date: Dec 2006
Posts: 57
Thanks: 0
Thanked 0 Times in 0 Posts

It looks like someone received an answer from MS.

Read thread 25 Jan 2006, 9:47 AM UTC

Adam Gossage
Lake Wylie, SC, USA

Similar Threads
Thread Thread Starter Forum Replies Last Post
Database migration MS Access 2003 to MS SQL 2000 ayazhoda SQL Server 2000 3 April 23rd, 2007 11:38 AM
MS ACCESS 2003 FRONTEND AND MS SQL SERVER 2005 DB mohankumar0709 SQL Server 2005 3 March 23rd, 2007 12:48 AM
MS Access 2003 Wizards russ_w_h Access 2 January 20th, 2007 11:23 AM
Access 2003 project and SQL server 2005 jesseleon Access VBA 3 February 23rd, 2006 12:03 PM
JRUN4 Unix with MS Access 2003 zaman1111 JSP Basics 0 February 10th, 2005 05:09 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.