BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Posted by Andy Brown on 21 December 2010
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Problem with Access Project ADP Table
Having just spent a while trying to solve an error with my Access project, I thought I'd share the solution!
The Problem
The error message in question is:
Our irritating message which appears within an Access project
The text equivalent of this is:
Microsoft 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'tblCourseware2',NULL,NULL)1'.　
* 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.
The message appears when you try to open a table in an Access project (that is, an Access database with file extension adp). I'm currently using Access 2010 and SQL Server 2008 R2, but I believe this problem occurs in all versions of Access after 2003.
The Solution
This error arises because the Access project is trying to get at the extended properties of a table, and these have been altered (in my case it was because I had scripted the table from another database).
The solution is to remove extended properties from the table in SQL Server and from all of its columns. First, show the properties of the offending table in SQL Server:
Next, delete all of the extended properties:
Now select each column of the table and do the same thing:
This should solve your problem!
Note that you probably don't need to delete all of the extended properties, as this blog post suggests.