Leaving Design Mode

%3CLINGO-SUB%20id%3D%22lingo-sub-1411857%22%20slang%3D%22en-US%22%3ELeaving%20Design%20Mode%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1411857%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20worked%20on%20Access%20for%20many%20year%20...%20and%20love%20it%20...%20BUT%20i%20am%20currently%20very%20frustrated.%26nbsp%3B%20If%20i%20try%20and%20execute%20an%20query%20from%20design%20mode%20it%20takes%26nbsp%3B%20f%20o%20r%20e%20v%20e%20r%20...%20even%20if%20i%20just%20want%20to%20design%20another%20query%2C%20it%20takes%20ages%20for%20the%20new%20query%20to%20initialise.%26nbsp%3B%20Has%20anybody%20else%20had%20this%20problem%20%3F%20I%20am%20also%20concerned%20with%20the%20%22(Not%20Responding)%22%20message%20in%20the%20title%20bar%20which%20appears%20all%20to%20frequently%2C%20even%20when%20Access%20is%20performing%20menial%20tasks.%20Does%20this%20happen%20to%20anybody%20else%20...%20even%20better%20if%20someone%20is%20aware%20of%20a%20solution%20to%20my%20current%20misery.%20i%20would%20really%20appreciate%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1411857%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%202007%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1413628%22%20slang%3D%22en-US%22%3ERe%3A%20Leaving%20Design%20Mode%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1413628%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F677046%22%20target%3D%22_blank%22%3E%40harold_dolman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThis%20problem%20can%20occur%20for%20several%20reasons%2C%20so%20we%20need%20more%20details%20to%20understand%20enough%20about%20YOUR%20specific%20situation%20to%20offer%20suggestions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20this%20happen%20with%20any%20query%2C%20or%20with%20just%20one%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20you%20trying%20to%20join%20a%20number%20of%20tables%20into%20a%20single%20query%3F%20Or%20is%20this%20a%20query%20on%20a%20single%20table%3F%3CBR%20%2F%3E%3CBR%20%2F%3EWhat%20parameters%2C%20if%20any%2C%20are%20applied%20to%20the%20query%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20you%20using%20any%20VBA%20functions%20in%20the%20query%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20appropriate%20fields%20in%20the%20table(s)%20to%20which%20the%20query%20is%20bound%20indexed%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20you%20specifying%20joins%20between%20tables%20--%20if%20multiple%20tables%20are%20involved%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20many%20records%20are%20in%20the%20table(s)%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20you%20working%20with%20tables%20linked%20from%20a%20remote%20server%20like%20SQL%20Server%3F%20Or%20another%20accdb%3F%20Or%20within%20a%20single%20accdb%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20providing%20sufficient%20background%20to%20address%20potential%20issues.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have worked on Access for many year ... and love it ... BUT i am currently very frustrated.  If i try and execute an query from design mode it takes  f o r e v e r ... even if i just want to design another query, it takes ages for the new query to initialise.  Has anybody else had this problem ? I am also concerned with the "(Not Responding)" message in the title bar which appears all to frequently, even when Access is performing menial tasks. Does this happen to anybody else ... even better if someone is aware of a solution to my current misery. i would really appreciate it.

1 Reply
Highlighted

@harold_dolman 


This problem can occur for several reasons, so we need more details to understand enough about YOUR specific situation to offer suggestions.

 

Does this happen with any query, or with just one?

 

Are you trying to join a number of tables into a single query? Or is this a query on a single table?

What parameters, if any, are applied to the query? 

 

Are you using any VBA functions in the query?

 

Are appropriate fields in the table(s) to which the query is bound indexed? 

 

Are you specifying joins between tables -- if multiple tables are involved?

 

How many records are in the table(s)? 

 

Are you working with tables linked from a remote server like SQL Server? Or another accdb? Or within a single accdb?

 

Thanks for providing sufficient background to address potential issues.