We currently have a Datasheet view that we have created in Microsoft Access 2013. This Datasheet have over 63 fields, several links/buttons, and conditional formatting.
ThIs datasheet has become slow over time and when I go to analyze performance, it states that the number of controls needs to be reduced.
1. Are there a total number of Controls that is ideal for the performance on a Datasheet?
2. Is there a way to conditional format a Row in the Datasheet rather than by individual fields?
3. what other thoughts do you have to improve the performance of a datasheet?
4. We are using a split database - would converting to SQL database for the data help the performance?
5. Many of the users are accessing the database through Access Runtime. Does this impact performance as well?