March 26, 2008 at 12:24 am
Hi,
I am just starting to use Microsoft Access Project 2003 linked with SQL Server Express 2005. When I try to create a new query in Project I get the following error messages:
------------------
This version of Microsoft Office Access doesn't support design changes with the version of Microsoft SQL Server your Access Project is connected to. See the Microsoft Office Update Web Site for the latest information and downloads. Your design changes will not be saved.
-----------------
You have connected to a version of SQL Server later than SQL Server 2000. The version of Visual Studio or Access that you are using was released before the version of SQL Server to which you are connected. For this reason, you might encounter problems.
Please check with Microsoft to see if there is a service pack that you should apply to Visual Studio or Office in order to get support for the version of SQL Server to which you are connected.
You can continue but any new object types might not be enumerated, and it will not be possible to save any objects or database diagrams that you create using the Visual Database Tools.
-----------------
Has anyone come accross this issue before? or have any suggestions for a fix?
Thanks
March 26, 2008 at 9:39 am
If you are using an Access adp, you should create your queries as views in the SQL Server Management studio.
March 26, 2008 at 4:56 pm
Ok Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply