Append query locks application

[Guest]

In an application I am working on, I import data from a number of linked
Oracle tables into local tables with slightly different structures. I do
this to preserve the users ability to work offline while disconnected from
the Oracle server.

A segment of this code looks like:

currentdb.execute "DELETE * FROM tbl_myTable", dbfailonerror
currentdb.execute "qry_myTable_append", dbfailonerror
****
The problem is that when it hits this particular append query, the
application locks up and I have to use the task manager to close Access.
When I run the query from the query grid or double click on the query in the
database window, it runs properly and inserts the 500 records in about a
second.

I have copied the SQL, deleted the original query, and created a new query,
but get the same results. Next step is to create a new database and import
all my objects to it. Would appreciate hearing any other recommendations.

 

[Guest]

Hi Dale

I assum your using XP (if not then this will not apply)
If you have not got the servicepack 2 (free download form MS) This "could"
be a problem with the entire append being flushed for each record - so if you
have 500 records you will flush the entire cache each time which will cause
your machine to ..... not have a happy time <

Take a look at
http://support.microsoft.com/kb/811113/

 

[Dale Fye]

Thanks, Wayne

Yes, I am using XP, and am unsure which SP the IT folks have installed.
I'll check it out