troubleshooting Question

Query takes too long to go from SQL to DESIGN view and vice versa

Avatar of pcalabria
pcalabriaFlag for United States of America asked on
Microsoft AccessVBASQL
26 Comments2 Solutions288 ViewsLast Modified:

I have a rather large Access 2K database (currently 700KB to 1.2KB depending upon when it was last compacted) that has started to exhibit extreme slowness when I go from SQL view to Design view and vise versa.  XP Pro platform split front end/back end

For example, some queries take ten minutes or more just to switch views.
(Not to run the query, just from the time I press the design view button)

What can I do?  This is a coding nightmare!
Join our community to see this answer!
Unlock 2 Answers and 26 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 26 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros