sonmic
asked on
Slow combobox in access
Hi,
I have an access database. The Frontend DB is installed local on my PC and the Backend on the server. When I open the combobox in the main-form then that take about 1 minute (the combobox contains approximately 1000 records). When i open this combobex a second time, then it opens immediately.
What is the reason for this delay?
Tx
I have an access database. The Frontend DB is installed local on my PC and the Backend on the server. When I open the combobox in the main-form then that take about 1 minute (the combobox contains approximately 1000 records). When i open this combobex a second time, then it opens immediately.
What is the reason for this delay?
Tx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
sonmic,
Just FYI,
There is a school of thought that would question why you are displayng 1000 items in a combobox.
;-)
If you narrowed down that list, it may be faster.
For example, if this is a list of Customers, have a selection somwhere to limit the customers to a certain geographic location.
;-)
JeffCoachman
Just FYI,
There is a school of thought that would question why you are displayng 1000 items in a combobox.
;-)
If you narrowed down that list, it may be faster.
For example, if this is a list of Customers, have a selection somwhere to limit the customers to a certain geographic location.
;-)
JeffCoachman
If the rowsource data does not change during a session then you could think about copying it into a local table as the database opens, and then using the local table as the rowsource.