By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,680 Members | 1,868 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,680 IT Pros & Developers. It's quick & easy.

Access Databases Much Slower To Load Under Vista

P: n/a
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.

Mar 18 '07 #1
Share this Question
Share on Google+
6 Replies


P: n/a
"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?
Mar 18 '07 #2

P: n/a
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!
Mar 19 '07 #3

P: n/a
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.
Mar 20 '07 #4

P: n/a
"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.
--
Mar 20 '07 #5

P: n/a
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.

Mar 20 '07 #6

P: n/a
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.

Mar 20 '07 #7

This discussion thread is closed

Replies have been disabled for this discussion.