97 to 2000 slow performance

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Francois Houde (FrancoisHoude_at_discussions.microsoft.com)
Date: 09/24/04 

Date: Fri, 24 Sep 2004 07:49:09 -0700

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 ?

Relevant Pages

  • Re: Distribute to user account objects in specific AD group in SCC
    ... For your second query, perhaps try using the subselect 'not in' ... This gave me a list of all the computers in the AD group. ... It does NOT work the same way as users in a usergroup. ... problem upon removing the computer account from the AD group and invoking ...
    (microsoft.public.sms.admin)
  • Re: Access to a custom table
    ... Create a collection based on this query for machines you want to include: ... "Tony" wrote: ... Let say I have computers named "A, B, C, D" in the database. ... > that has the NOT subselect query. ...
    (microsoft.public.sms.admin)
  • RE: How to combine existing collections to include or exclude...
    ... "Matthew Hudson" wrote: ... Servers you want minus the ones you don't want ... Add computers you don't want to show up in Collection B ... will see if I can't just send you the collection queries and the query ...
    (microsoft.public.sms.admin)
  • Re: How to combine existing collections to include or exclude...
    ... "Matthew Hudson" wrote: ... Servers you want minus the ones you don't want ... [edit query statement/Criteria] ... Add computers you don't want to show up in Collection B ...
    (microsoft.public.sms.admin)
  • RE: How to combine existing collections to include or exclude...
    ... is selecting the computers in my remote offices via AD but limits it only to ... select the query and say "computer name" not it limited ... This will grab all the computers that are in the limited collected minus the ...
    (microsoft.public.sms.admin)