Hello,
I would like to know if somebody met a similar issue:
I have recently started a new job where I have rather decent software and hardware - intel i7, 32GB ram, 64bit W8 & 64bit Office '13. Therefore I have no clue what is a source of my problem which is the fact that Ms Access works just extremely slow. For example running a simple select query on a table uploaded from 100K-rows-excel can take even 5minutes; what makes Access unusable. In the task manager I have noticed that Access never uses more than around 5% CPU and memory, it just hangs and calculates slowly. Other Office Tools like Excel are able to use the 100% and work effectively.
I have tried to follow some Access-accelerating solutions such as turning off the AutoCorrect, but nothing has worked so far and it is killing me that I used to have 20 times worse hardware&software and still it worked faster than now. I would really appreciate your suggestions!