Access 2000连接到SQL Server 2005 [英] Access 2000 connecting to SQL Server 2005

问题描述

我工作的公司有一个使用SQL Server 2000后端的旧Access 2000应用程序.我们的任务是将后端移动到新服务器上的SQL Server 2005数据库中.不幸的是，尝试进行任何插入或更新时，应用程序无法正常运行.我的研究发现许多论坛帖子都表明Microsoft不支持Access 2000-> SQL 2005，但是我找不到任何Microsoft文档来验证这一点.

The company I work for has an old Access 2000 application that was using a SQL Server 2000 back-end. We were tasked with moving the back-end to a SQL Server 2005 database on a new server. Unfortunately, the application was not functioning correctly while trying to do any inserts or updates. My research has found many forum posts that Access 2000 -> SQL 2005 is not supported by Microsoft, but I cannot find any Microsoft documentation to verify that.

任何人都可以将我链接到一些官方文档，或者有人使用过该设置并可以确认该设置是否有效并且我们的问题出在其他地方吗?

Can anyone either link me to some official documentation, or has anyone used this setup and can confirm that this should be working and our problems lie somewhere else?

不确定是否重要，但该应用程序是编译为ADE的ADP.

Not sure if it matters, but the app is an ADP compiled into an ADE.

推荐答案

在使用ODBC链接表连接到Sql Server之前，我遇到过类似的问题.解决方案是重新链接表并指定表的主键.如果Access不知道主键，它将无法执行插入或更新.

I've had a similar problem before when using ODBC linked tables to connect to an Sql Server. The solution was to relink the tables and specify the primary key to the table. If Access doesn't know the primary key it cannot perform inserts or updates.

我没有使用ADP的经验，但这可能是类似的事情，这里有一篇有关它的知识库文章 http://support.microsoft.com/?scid=kb%3Ben-us%3B235267&x=15&y=13

I haven't any experience with ADPs but it could be a similar thing, theres a knowledge base article about it here http://support.microsoft.com/?scid=kb%3Ben-us%3B235267&x=15&y=13

这篇关于Access 2000连接到SQL Server 2005的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！