Access Databases Much Slower To Load Under Vista

[Wayne]

Has anyone noticed that Access databases (2003) are much slower to
load under Vista or is it just me? I have a dual boot machine (XP and
Vista). Applications generally are a bit slower to load under Vista,
Access included, and an Access DB of say 5mb size takes several
seconds to load out of memory under Vista and is instantaneous under
XP. Speed is definitely not one of the new OS's strong points.

[lyle fairfield]

"Wayne" <cq*******@volcanomail.comwrote in news:1174260176.907904.208600
@d57g2000hsg.googlegroups.com:

Has anyone noticed that Access databases (2003) are much slower to
load under Vista or is it just me? I have a dual boot machine (XP and
Vista). Applications generally are a bit slower to load under Vista,
Access included, and an Access DB of say 5mb size takes several
seconds to load out of memory under Vista and is instantaneous under
XP. Speed is definitely not one of the new OS's strong points.

What strong points?

[Wayne]

What strong points?

Fair comment Lyle. I think MS is relying on the Aero interface and
"flip 3D" to sell the thing to the unsuspecting. From what I read on
the web, gamers don't have much good to say about it either. To me,
speed in an OS is everything and I don't think it's unreasonable to
expect things to happen quickly when I click the mouse in this age of
multi gigahertz processors and bucket loads of ram. XP in it's
current state is acceptable to me.

Why MS continues to release operating systems that are slower than
their predecessors is beyond me. But I guess we keep shelling out our
hard earned cash for them!

[Wayne]

Is anyone else experiencing this behaviour. As stated in my earlier
post, if I double click an mdb file of about 5meg that is cached in
memory under XP, it opens instantly. If I do the same under Vista,
Access opens immediately, then I am left staring at the hourglass for
about 3 seconds before the actual database opens. Surely this
shouldn't be happening.

[lyle fairfield]

"Wayne" <cq*******@volcanomail.comwrote in news:1174373046.991864.230930
@l75g2000hse.googlegroups.com:

Is anyone else experiencing this behaviour. As stated in my earlier
post, if I double click an mdb file of about 5meg that is cached in
memory under XP, it opens instantly. If I do the same under Vista,
Access opens immediately, then I am left staring at the hourglass for
about 3 seconds before the actual database opens. Surely this
shouldn't be happening.

Did you mention the Access version in which the mdb was created, and Access
version being used in Vista? I found this problem when I used Access 2003
dbs in Access 2007. It went away when I recompiled the file in Access 2007
so I suppose it wasn't caused by VISTA. This, of course, may have not have
caused the speedup; who knows with MS these days?
I expect we can all look forward to a 500 meg VISTA SP1 download and
installation that will cure everything, expect those things that will be
cured in some later one gig SP2 download. Maybe we should have a CDMA pool
on the date of these events.

David was probably right when he suggested that it's not wise to install
anything MS until SP1 is alive and well and available. On the other hand, I
reinstalled Windows XP a few weeks ago and was appalled at finding there
were more than one hundred (113?) updates required, and a bunch more
optional. Who wouldn't enjoy that?

I used to think MS was sincere in trying to create good software but there
were just too many things involved in their development business for them
to keep track of and anticipate everything. I don't think that anymore.
Maybe it's those PC-Mac commercials.

I can't recheck anything as I have passed on my VISTA and Office 2007
machines to more eager hands.
--

[Wayne]

Thanks for the feedback Lyle. Yes, it is an Access 2003 database, but
it's not just this particular DB that is slow to open - it's all of
them when I open them using Vista. I think you are dead right about
the service packs. Hopefully they will fix more than they break. I'd
like to continue using Vista, but there are so many niggling little
things, like the issue that prompted my original post, that I keep
going back to choosing a "previous version of Windows" (XP) when my
machine is starting up. At least I know it's reasonably stable and
very fast compared to the latest offering.

Even simple tasks like opening Control Panel or right-clicking on "My
Computer" then choosing "Manage" take an age to happen under Vista
compared to the time they take under XP. My machine isn't the newest
but with a 2.2 gig processor, 2 gigs of ram and a 10000RPM hard drive
it should run Vista well, but it doesn't.

Roll on the service packs.

[Wayne]

Since my previous post, I've found that Excel spreadsheets are doing
exactly the same thing under Vista. Excel will open immediately and
then a 20k spreadsheet (not exactly huge) will take a good 2 to 3
seconds to open. Under XP the same thing opens in microseconds.