Software

Ask something
Discussion Locked

Access Database Performance

0 helpful
7 replies

by sakil

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I created an Access Help Desk program for my company. The main form has numerous controls, a subform and linked to another table in a database. When I open the form it takes about 32 seconds to open up(we timed it). This is very slow. I've run the performance analyzer on it and it said the "Form has too many controls." All of the field controls are needed to give the proper Help Desk information.

Are there any suggestions?

Thank you.

7 replies

by shmaltz

If you use Macro for the controls then change it to VBA. If you use VBA then change it to HTML.

by donq

Strange problem! I don't see how any number of controls should affect anything beyond the Form's load time! (if each machine has enough RAM to load you application)

Do each of your control's call a query, and do they cascade based on a finding produced as a called procedure operates? Is everything indexed to maximize efficiency, and most importantly is your entire data source normalized (and then indexed to produce efficient recordsets?

There's not much information for us to go on and it sounds as though your project was quite substantial?

by it_cowboy

You will need to address the amount of data that is referenced by your controls, particularly list boxes and combo boxes. When an Access form opens, it will populate all the controls on a form before the form is available.

I have a similar problem, so for the controls that 'may' be required, i populate them on the SetFocus event for that control, rather than when the form opens. You will still cop a performance hit, but it depends on where you want the hit, when the form opens, or when youaccess a control.

This discussion is closed to new replies.