Speed problem with data

Question

I have an Access form with 10 tab detail items. Each detail tab has a sub form. Each sub form has a unique control source.
Above the tabs there is a combo box. When a new item is selected in the combo box all the sub forms has to be updated. The data is stored on a linked accb back end database on a server.

Performance is slow. Where can I look for performance gains?

Answer 1

Performance is slow. Where can I look for performance gains?

Hi Arne,

Can all data be retrieved using (primary or alternate) keys? This also includes the connecting field in the joins.

Do you use functions in the queries? These slow them down too.

Imb.

Answer 2

Imb,

Yes, I am missing indexes. How do I make an Access index primary?

Yes, I use queries. What is the alternative for record source?

Answer 3

Yes, I am missing indexes. How do I make an Access index primary?

Yes, I use queries. What is the alternative for record source?

Hi Arne,

Indexes: You can go to Table design, and there click the button for the keys

Queries: Queries can contain fields, but also functions working on the fields. These functions can slow down performance.

Imb.