EXEC sp_MShelpcolumns

[sixteamparlay]

We have an ADP which runs fast in access 2000

The same adp runs significantly slower when opening forms in Access 2007.

An Sql2005 trace reveals the following statement being executed only when the adp is run from Access 2007 and taking over a second

EXEC sp_MShelpcolumns N'tblname', NULL, N'id', 1

Any idea why this would be executed in Access 2007 but not Access 2000?

Thank you

 

[sixteamparlay]

FYI, anyone else having this problem this may help. Since we made the jump from Access 2000 to Access 2007, a new property is added to each form called FetchDefaults and defaults to "YES".

Setting this property to NO on every single form speeds things up alot since it doesn't execute the SP_MSHelpColumns when "NO".