I see this was asked and answered long ago here
, but the accepted answer didn't really present a practical fix.
Problem: Legacy Access 2000 ADP application referencing a SQL Server database which has been ported up to Access 2007. The application works, but throws hundreds of calls to SQL looking for extended properties on tables per minute! Calls are like:
SELECT *, sql_variant_property(value
, 'basetype') AS type FROM ::fn_listextendedproperty(
A good many folks on Google suggest setting the table's MS_SubdatasheetName extended property to "NONE", but this hasn't worked for me.
Has anyone managed to solve this problem?