Slow combos - have tried many things

[PurpleUnicorn]

I am having intermittent problems with an Access database.

It was developed in Access XP – running on Windows XP/Access 2003.
Split, FE on desktops, BE on Win2000 server

I have 3 forms that have combo boxes that pull data from the same (customer) table.
All three have autofill property on.
One of them performs satisfactorily, the other 2 take a long time to display what has been typed – most of the time.

Here is what I have tried so far: (many ideas from this great website)

Checked indexes on the recordsource table – they are perfect.
Compacted the data.
Changed the recordsource for the slow combos to a stored query.
Added a Form_Load event to perform combobox.listcount to fill the combobox.
Checked the table design and set the subdatasheet name to none
Decompiled, compacted, recompiled and compacted the application.
Imported all objects into a clean mdb and re-created the links.

The client (I am not always on site) copied data to desktop, linked to it – still slow
Created empty mdb – imported data (on desktop) – still slow.

All to no avail -

I just had the data and application sent to me – when I test it on my PC, it works great.

I am totally baffled! Words can not express my frustration!

Any help will be greatly appreciated.

 

[PurpleUnicorn]

I am now on site and have additional information. I hope someone can offer some helpful advice.

When I am connected to the data on the server - and I begin typing a customer name in my combo box, the letters appear painstakenly slow - especially if the name is closer to the end of the alphabet.

I have made a form with a combo(with the query above) as the only control - it is slow. The query is simple - select id, name from table order by name - with id the primary key. There is an index on name. The query, by itself runs very fast - just the autofill on the combo is slow.

Any ideas??

Thanks

 

[PHV]

How many items in the combo ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[PurpleUnicorn]

Currently, there are around 21,000 records in the table. The entire data mdb is about 43mg.

There are 2 different Access applications running. All have the application on the desktops and the 2 data files reside on the same server. The applications are similar (there are 2 divisions within the company). The other division is not experiencing the problem and they have more data.

Any ideas will be greatly appreciated.