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.