[AccessD] Weird query execution problem.

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




More information about the AccessD mailing list