sql-server - Access 数据项目错误

Question

我有一个连接到 SQL 服务器数据库的 Access 数据项目。最近我从SQL服务器修改了数据库的结构。现在，每当我尝试打开其中一张表时，都会出现以下错误。

Microsoft Office Access can't find the object 'SELECT *, sql_variant_property(value, 'basetype') AS type FROM ::fn_listextendedproperty(N'MS_DisplayViewsOnSharePointSite',N'user',N'dbo',N'table',N'Hardware',NULL,NULL)'.

• You misspelled the object name. Check for missing underscores ( _ ) or other punctuation, and make sure you didn't enter leading spaces.
• You tried to open a linked table, but the file containing the table isn't on the path you specified. Use the Linked Table Manager to update the link and point to the correct path.

我试图创建一个新的 Access 数据项目，看看它是否仍然发生在那里......它确实发生了。

Answer 1

显然是删除了 MS_Filter和 MS_OrderBy表上的扩展属性将解决这个问题。

来源和说明: Strange Microsoft Access Error on ADP project (Sql Server 2005 Extended Properties)