Bobby Heid
bheid at appdevgrp.com
Wed Jul 28 13:56:39 CDT 2004
Just to let you know, I had to make the query accept parameters so that it would only operate on a range or payroll records. I my initial testing, I broke the payroll ID filed into 4 ranges and ran it on each range. It works fine now. 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 11:13 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Weird query execution problem. Hi Jim, That did not work either. I think that I'll pass parameters to the queries so that I can process the data in chunks. Thanks for trying, Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Tuesday, July 27, 2004 10:18 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Weird query execution problem. Bobby, Open up the queries and set the UseTransaction property to no. See if that clears up the problem. Jim Dettman (315) 699-3443 jimdettman at earthlink.net -----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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com