General discussion

Locked

Access Database Performance

By sakil ·
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.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access Database Performance

by shmaltz In reply to Access Database Performan ...

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

Collapse -

Access Database Performance

by sakil In reply to Access Database Performan ...

Poster rated this answer

Collapse -

Access Database Performance

by donq In reply to Access Database Performan ...

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?

Collapse -

Access Database Performance

by sakil In reply to Access Database Performan ...

Poster rated this answer

Collapse -

Access Database Performance

by IT_Cowboy In reply to Access Database Performan ...

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.

Collapse -

Access Database Performance

by sakil In reply to Access Database Performan ...

Poster rated this answer

Collapse -

Access Database Performance

by sakil In reply to Access Database Performan ...

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums