monozygotic1_2@hotmail.com wrote:[color=blue]
> 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.[/color]
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
