SP2 seriously Impacts Access 97 Performance

[monozygotic1_2]

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.

[Bri]

mo************@hotmail.com wrote:

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.

Do you mean the Office 97 SP2 update, or the WinXP sp2 Update?

I have been sucessfully using the Office 97 SP2 update for years now and
saw no degrading of performance from it. You might want to try doing a
Decompile (on a Copy), a compact, compile, another compact.

I have clients running WinXP sp2 without any slowdowns. In fact it has
improved the performance of record inserts on the network BE as it has
better recordlocking collision avoidance abilities.

--
Bri

[David W. Fenton]

mo************@hotmail.com wrote in
news:11*********************@g10g2000cwb.googlegro ups.com:

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/