<div>
Hi Kelvin,<br />
THX Yes you were right removing the where clause slowed down the query performance dramatically.
</div>


Hi Kelvin,
THX Yes you were right removing the where clause slowed down the query performance dramatically.

<div>
Dear expoerts,<br />
@Gustav, THX for your answer. Sorry noticed it too late, I asked the moderator so split the points between you and Kelvin.
</div>


Dear expoerts,
@Gustav, THX for your answer. Sorry noticed it too late, I asked the moderator so split the points between you and Kelvin.

<div>
<div class="content wysiwyg-content">
Dear Experts.<br />
I have a MSAccess query which runs well. Now I have to apply a minor change - remove a where clause.<br />
When I change the query and save it, it does NOT execute anymore. When I run the query, MSAccess stalls with the hour glass cursor and does NOT execute the query, I have to kill MSAccess via the Task Manager.<br />
The query is based on all local tables. The amount of data is low, the main table has 3000 entries. However the query has about 30 left joins to all local tables.<br />
I tried: copy the query and paste, direclty via copy/pase -&gt;did not solve the issue.<br />
Copy the SQL code, made a new query, pasted the SQL code. The query is valid, can be viewed in design mode -&gt;still not executing.<br />
COmpacted/repaired the DB<br />
Nothing solved the issue, I have no further ideas.<br />
Any help is VERY appreicated
</div>
</div>


Dear Experts.
I have a MSAccess query which runs well. Now I have to apply a minor change - remove a where clause.
When I change the query and save it, it does NOT execute anymore. When I run the query, MSAccess stalls with the hour glass cursor and does NOT execute the query, I have to kill MSAccess via the Task Manager.
The query is based on all local tables. The amount of data is low, the main table has 3000 entries. However the query has about 30 left joins to all local tables.
I tried: copy the query and paste, direclty via copy/pase ->did not solve the issue.
Copy the SQL code, made a new query, pasted the SQL code. The query is valid, can be viewed in design mode ->still not executing.
COmpacted/repaired the DB
Nothing solved the issue, I have no further ideas.
Any help is VERY appreicated

MSAccess Query stalls

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.