97 to 2000 slow performance

[Francois Houde]

I have a small application with 1 form, 1 table and 2 query. The form is the
startup object and it calls query 1 which deletes all rows in a table and
then calls query 2 which read an AS/400 table and fills the access table.
The application is run with access runtime and not the full version of access.

In access 97 this process takes 30 seconds. We convert it in access 2000
and for the first test this morning we stopped the process after 2h30. We
know it's not the ODBC because we have other application that uses this ODBC
and everything work fines. On other computers everything work fines. All
computers are of the same brand and all application are installed the same
way with a ghost.

Any idea on what could be the problem ?

 

[david epsom dot com dot au]

Presumably, it is reading or deleting a table one row at a time,
instead of doing a bulk update/bulk read/bulk delete. You should
make sure that Access/DAO/Jet/MDAC/ODBC is fully updated, simplify
the actions, and then.... look to see if there are any arcane
changes that you can make to improve the situation.

(david)