When i run large access queries, Access seems to take over the whole PC. Its difficult to switch to another task.
I have a pc with 1 GB RAM. What can be done. Any tricks???
Make sure your tables are properly indexed. Only return the records you really need. Use good sql syntax. Don't use domain aggregate functions in queries.
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.