Tables open slowly

[srferson]

I have a user who was complaining because a particular database feature that she uses a lot is running painfully slow. And it's true. It is ridiculous.

So I was trying to figure out why. What I noticed is that it's taking her computer a lot longer than others to open tables. It doesn't matter if it's a local Access table or if it's linked to SQL. It opens unusually slowly.



1. She has a newer computer with plenty of memory.
2. She's on the same network as the other users and I didn't notice other things on the network taking unusually long to open.
3. If I open a form, it will open quickly, but maybe that's because while it does load all the records, it only needs to have loaded one for the form to open. At least I assume that makes a difference.

Has this kind of thing been a problem for anyone else? Does anyone have any idea why this might be happening?

Thanks.

[NTC]

"doesn't matter if it's a local Access table or if it's linked to SQL"

?? by this one guesses you mean a local table vs a linked table. so you have moved the BE onto the same computer - eliminating the network - and opening a table from the FE is as slow as when the BE is located elsewhere on the network?? that is rare.

when the BE is on that computer - open a table (without using the FE)...is it slow still? presuming not - - delete the FE and reinstall a new one....