Access Data Project Error

Question

I have a Access Data Project that connects to an SQL server database. Recently I modified the structure of the database from the SQL server. Now whenever I try to open one of the tables, I get the following error.

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.

I tried to create a new access data project and see if it still happened there... and it does.

Answer 1

Apparently deleting the MS_Filter and MS_OrderBy extended properties on the table will resolve this.

Source and instructions: Strange Microsoft Access Error on ADP project (Sql Server 2005 Extended Properties)