[AccessD] Access 2007 hangs on Save of Query

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Mon Mar 9 13:08:38 CDT 2009


Workaround: but if you have 2003 could you structure the query in 2003 and
import it into 2007.  Or save the mdb in 2003 format and try to do it in 03
and then convert back to 07?


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rojas, Joe
Sent: Monday, March 09, 2009 10:35 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Access 2007 hangs on Save of Query

Hi All,

Just wondering if anyone else has encountered the following.

I have a query that left joins 20 other queries to a "main" query.
I don't have any problems building the query in design view but each time I
go to save it Access hangs or locks up.
By that I mean the CPU pegs out at between 50% and 100% (Running a dual
core) and the Access title bar will say "Not Responding".
I've been waiting for a long time and it is still chugging away.

Joe

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list