Updated subject: Query failing to execute WAS: RE: [AccessD] Combobox question UPDATE

Bobby Heid bheid at appdevgrp.com
Wed Jun 30 14:30:53 CDT 2004


I let it run during lunch and it finally did get through the query.  It
updated about 48000 records.

I still do not know why it is taking so long.  I even took off almost all of
the indexes of the payroll table and it still took a very long time.

Any ideas?

Thanks,
Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bobby Heid
Sent: Wednesday, June 30, 2004 11:41 AM
To: 'Access Developers discussion and problem solving'
Subject: Updated subject: Query failing to execute WAS: RE: [AccessD]
Combobox question


Sorry about that.  I forgot to change the subject.

Bobby


-----Original Message-----
From: Bobby Heid [mailto:bheid at appdevgrp.com] 
Sent: Wednesday, June 30, 2004 11:40 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Combo box question


Hi all,

I have a query that is run during a conversion of a database that appears to
be hanging on this one particular database.

Here's the query:
UPDATE Contract 
	INNER JOIN [Payroll Line Items] 
		ON Contract.[Contract ID] = [Payroll Line Items].[Contract
ID] 
	SET [Payroll Line Items].PolicyID = [EnforceWCID]
	WHERE [Payroll Line Items].CostType='WC' 
		AND Contract.EnforceWCID<>0;

This query is placed into a string and executed with: db.execute
strSQL,dbfailonerror

There are ~192,000 payroll records and ~3500 contract records.

If I copy the SQL into the query designer and run it, it only takes about 5
seconds or so to execute.  I have let the version in the code run for over
1/2 hour and have to end up killing access.

Anyone have any ideas as to what may be happening?  I am running AXP sp2.
The tables are linked.  This code has ran fine on over 100 other
conversions.

Thanks,
Bobby

-- 
_______________________________________________
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