Hello,
i wanted to ask if it is commonly experienced, that nested queries are veeerryyy slow in access.
I have written some queries directly in SQL view that use other queries, and it is really slow, although there is not much data or other things.
My access doesn't respond for 2 minutes and then the query finishes. Is there something special about access that makes it slow in that case ?
Thanks in advance,
fluppe