Re: SP2 seriously Impacts Access 97 Performance

monozygotic1_2@xxxxxxxxxxx wrote in
news:1143745227.838777.55880@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:

I have a database that is built in Access 97 that was perorming
quite well. After my company upgraded to SP2 it wreaked all kinds
of havock, and I spent weeks resolving all the issues. A form that
opnened in less than a minute would take up to twenty minutes.

I have several queries that contained two tables with a left outer
join. Before the upgrade the quries ran in seconds. After the
upgrade it took minutes for them to run. After changing the joins
to inner joins the queries again ran in seconds. I called
Microsoft Technical support to see if I could get an explanation
and was given a brush-off because Access 97 is no longer a
supported product.

Can anyone tell me why this would be? Thank you so much for any
assistance in this matter.

Why would anyone ever use an outer join in a situation where an
inner join would work?

I never saw any such problem with slowdowns for outer joins.

What version of Jet did you end up with?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Cannot upgrade to WinXP HE
    ... I'm trying to upgrade a Win98SE PC to XP Home Edition. ... Contact Microsoft technical support ... I tried to email MS tech support, but they require the product code from the ... installing from there. ...
    (microsoft.public.windowsxp.setup_deployment)
  • Fatal Error during XP install
    ... While attempting to install XP Pro - upgrade or clean ... install; I get the following error message: ... Setup cannot continue.Contact Microsoft Technical Support ...
    (microsoft.public.windowsxp.setup_deployment)