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