Hi,
My DB is becoming very slow in response when opening and closing forms
I have linked files to other back ends
the data transfer for lookup in other back ends seems to be at a good speed
it only seems to be when opening and closing forms or moving between form
i made a copy of the DB, removed the forms, queries using the linked tables and also removed the linked tables, no difference in the speed of remaining forms
I made all the linked tables local tables, no increase in performance
update queries run at a good speed
when i am in a form and select data from a drop down box which looks up data in a external linked file, the speed seems to be adequate
I ran a compact and repair on the back and front end
any suggestions please?
My DB is becoming very slow in response when opening and closing forms
I have linked files to other back ends
the data transfer for lookup in other back ends seems to be at a good speed
it only seems to be when opening and closing forms or moving between form
i made a copy of the DB, removed the forms, queries using the linked tables and also removed the linked tables, no difference in the speed of remaining forms
I made all the linked tables local tables, no increase in performance
update queries run at a good speed
when i am in a form and select data from a drop down box which looks up data in a external linked file, the speed seems to be adequate
I ran a compact and repair on the back and front end
any suggestions please?