Access Performance Analyzer

[teachme]

Hi,

Is it required or recommended to run the performance analyzer and fix any recommended issues.

I am just finishing up with my db and I ran the performance analyzer. There were no errors with tables or queries but there is a whole bunch of 'idea' from access on my forms. I am not sure if its worth the time to go through each.

I looked up the first one and it has tells me to add Option explicit statement for a particular form. Well...that particular form doesnt have any code behind it so I am not sure what this is about.

See attached.

Your thoughts?

Thank you

 

[CJ_London]

that particular form doesnt have any code behind it so I am not sure what this is about

perhaps you had some code and then deleted it all. If there is no code, recommend you change the form 'has module' property (in the Other tab) to No

 

[teachme]

perhaps you had some code and then deleted it all. If there is no code, recommend you change the form 'has module' property (in the Other tab) to No

Yup, that worked - thank you