Bobby Heid
bheid at appdevgrp.com
Tue Jul 27 07:49:37 CDT 2004
Sorry, I forgot specifics. Access XP sp2 Win2K sp3 The queries are update queries. Thanks, Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bobby Heid Sent: Tuesday, July 27, 2004 8:34 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Weird query execution problem. Hi all, Me again with another problem. I have these three queries that normally run fine on most BEs that I throw at it. These databases have between 1500-50000 payroll records. I have a large database with 193000 payroll records. I am running the queries from code using db.execute "queryname",dbfailonerror. When processing the large database, Access appears to stop running. It runs up to the offending queries and stops. I show 0% cpu for access when this happens. I have let it go for over an hour before and still no go. So yesterday, I stopped the program right before the queries. I then went to the query list and double-clicked each of the three queries and they ran fine. Anyone have any ideas as to what may be going on? I am going to try running them in code using a querydef. Thanks, Bobby -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com