访问97前端-SQLServer2005后端链接表错误-Access97Frontend-SQLServer2005BackendLinkedTableError

I have a legacy Access 97 Frontend application which utilises a SQL Server 2005 backend over a SQL Server ODBC Driver (Connection), we use the Linked Table feature on this setup.

我有一个遗留访问97前端应用程序，它使用SQL Server 2005后端，而不是SQL Server ODBC驱动程序(Connection)，我们在这个设置中使用链接表特性。

I create, amend and link in tables on a daily basis and I am aware of the conversions that occur between the different data types.

我每天都在表中创建、修改和链接，我知道不同数据类型之间发生的转换。

There seems to be an issue with one table that I recently created, it has exactly the same setup and permissions as many of the other tables in the database but once I link it into Access 97 it seems to show #NAME in all columns and I also receive an 'ODBC Call Failed' error.

似乎有一个问题我最近创建的表,它有完全相同的设置和权限的数据库中的其他表但是一旦我链接到访问97似乎显示在所有列#的名字我也收到一个“ODBC调用失败”错误。

If I remove the Primary Key from the table and do not select a 'Unique Record Identifier' then I am able to view the data in the table but I obviously can't edit it.

如果我从表中移除主键，并没有选择“唯一的记录标识符”，那么我就能够查看表中的数据，但显然我不能编辑它。

There are 3 columns which are VARCHAR's and are over 255, if I reduce these columns to 255 or less I am then able to view the data in the table but if I then try to edit or delete the data I receive a new error 'The Microsoft Jet Database engine stopped the process because you and another user are attempting to change the same data at the same time' - I know this is not possible because at present I am the only one with access to the table.

有3列VARCHAR和超过255,如果我减少这些列255或更少我可以查看表中的数据,但如果我要编辑或删除的数据我收到一个新的错误的Microsoft Jet数据库引擎停止这个过程因为你和另一个用户正在试图改变相同的数据在同一时间的——我知道这是不可能的,因为目前我唯一一个对表的访问。

In this particular table there are 146 columns, if I delete half of these then the table starts to work as it should, again I have tables that have far more columns than this and work perfectly.

在这个特殊的表中有146列，如果我删除了其中的一半，那么这个表就开始正常工作了，同样，我有比这个多很多列的表，而且工作得很好。

1 个解决方案