Performance Analyzer Recommendation

[M Skabialka]

I ran the Performance Analyzer on my new Access 2007 database on WinXP. One
of the suggestions is:
Table 'MSysObjects': Add an index to field(s) 'Type'

I selected the suggestion and chose Analyze but when I ran it again the same
thing showed up.
What exactly is this telling me to do?
Mich

 

[Stefan Hoffmann]

hi Mich,

I ran the Performance Analyzer on my new Access 2007 database on WinXP. One
of the suggestions is:
Table 'MSysObjects': Add an index to field(s) 'Type'

As this table is an Access system object, you should ignore that hint
and make no changes to it.


mfG
--> stefan <--

 

[M Skabialka]

I wonder why it is recommended? But I'll leave well enough alone..
Thanks,
Mich