SP2 seriously Impacts Access 97 Performance

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

monozygotic1_2@hotmail.com - 30 Mar 2006 20:00 GMT

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.

Reply to this Message

Bri - 30 Mar 2006 22:39 GMT

> 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,
[quoted text clipped - 10 lines]
> 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

Reply to this Message

David W. Fenton - 31 Mar 2006 00:01 GMT

> 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
[quoted text clipped - 11 lines]
> 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?

Signature

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

Reply to this Message