[AccessD] Weird query execution problem.

Hey Gustav,

The databases are local.

I have stopped the code at the queries.  It is at least the first two.
There are many other queries (this is a conversion from and earlier version)
around these.

These queries run fine on other databases.

I also just tried to run the first query using a querydef and got the same
results.

Thanks,
Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Tuesday, July 27, 2004 8:57 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Weird query execution problem.


Hi Bobby

I would try stopping the code (by a msgbox) before and in-between the three
queries. Perhaps it is only one of the queries that causes trouble. Also,
try running the code when the database is stored locally. Networks and wrong
settings on file servers can cause errors.

/gustav


> 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