Report and Query Speed ..

[fekrinejat]

Hello, I have a complex access 2000/2003 DB (50 MB Size) it has been working fine so far , for example
running a huge report would takes around 5 seconds but this morning i just added a field in a query
and suddenly speed decreased to 25 Seconds for the same report , Although i used Compact and Repair
DataBase Tool but nothing changed ..


I usually change my DB twice or three times in month but hadn't seen such a problem ..
any idea ?
Thank You

[Christian1977]

Hi fekrinejat,

have you tried to run it on another Notebook?

[fekrinejat]

Hi Dear Christian
I have tried it on 5 computers included computers on network but same result ..

[June7]

Do you want to provide the db for analysis? Follow instructions at bottom of my post. Identify the objects and the field involved in issue.

[Christian1977]

Hi fekrinejat,

if you post the db I'll give it a look!

Have a nice day!

[fekrinejat]

Hi
Sorry, Unfortunately I can't send DB due to security and the size of the file reason ..
but any idea would help me
Thanks

[Christian1977]

Hi,

I opened a new discussion and Bob provide us an interesting link in order to analyze the access db. Try and let us know. Regards.

https://www.accessforums.net/access/...-db-35729.html