Tips for optimizing data access page performance

There are several things you can do to make your data access pages load faster in Page view or in Microsoft Internet Explorer 5.

• Avoid overlapping controls.
  
  
• Use bitmaps and other graphic objects sparingly. Use black-and-white rather than color bitmaps.
  
  
• Make sure the ExpandedByDefault property in the Sorting And Grouping box is set to No for highest group level. Setting it to No for lower group levels will speed up other interactions after the page is opened.
  
  
• Make sure the DataPageSize property in the Sorting And Grouping box, which determines the number of records displayed in a group on a page, is set to a low rather than a high number, or is set to All. The lower the number, the faster the records are displayed.
  
  
• Use bound HTML controls instead of text boxes to display any data that isn't updateable — for example, to display autonumbered values, values derived from expressions, and hyperlinks.
  
  
• On grouped pages, use bound HTML controls instead of text boxes to display data.
  
  
• When using a data access page within Microsoft Access, close all database objects that aren't being used.
  
  
• When using a data access page in Internet Explorer, close all windows that aren't being used.
  
  
• On data access pages that are used for data entry, set the DataEntry property of the page to Yes so that the page opens to a blank record.
  
  
• Index any fields that you sort, group, or filter on.
  
  
• On grouped data access pages that contain records with a one-to-many relationship, group records by table rather than by a field or expression.
  
  
• On grouped data access pages based on tables with a one-to-many relationship, bind each section to a table rather than to a query. Microsoft Access retrieves the records from a table only as it needs to display them on the page. With a query, Access retrieves all the records before it displays any records on the page. Use a query only when you want to limit the data used on the page, calculate aggregate values, or perform a task that's possible only in a query.