473,287 Members | 1,793 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

Access Databases Much Slower To Load Under Vista

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
6 2021
"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
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
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
"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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
by: Mike MacSween | last post by:
Sorry if this is a bit off topic, but I can't seem to find a 'remote control' newsgroup on my news server. And anyway I know Tony has some experience of this. The app is split FE/BE. I'd like...
77
by: Peter Olcott | last post by:
http://www.tommti-systems.de/go.html?http://www.tommti-systems.de/main-Dateien/reviews/languages/benchmarks.html The above link shows that C# is 450% slower on something as simple as a nested loop....
38
by: kavsak | last post by:
Hi. Not sure that this is the right place to ask but here goes. I have an application based on access97 and VB6 which I need to upgrade. It has to handle up to 20 concurrent users on a Win2k...
13
yolenman
by: yolenman | last post by:
Hello - This is my first posting to this group, so please bear with me. Also note, that while I'm intelligent, databases are not in my field of knowledge. I'm working with a small limousine...
2
by: Wayne | last post by:
I'm experiencing the following intermittent problem with Access 2003 (Access 2000 file format) under Vista. Sometimes when I close a database by closing the database window I get the following...
8
by: chu2ch | last post by:
Good Day Folks, We have an .net 2.0 application that has been working reasonably well in windows xp, we have installed our application on windows vista business and have noticed a significant...
12
by: ARC | last post by:
I'm currently looking at the access developer extensions for creating an MSI installer package for a 2007 runtime app. Couple of observations and questions. 1) Doesn't look like we have the...
10
by: Arno R | last post by:
Hi all, So I bought a new laptop 10 days ago to test my apps with Vista. (home premium) Apparently Office 2007 is pre-installed. (a time limited but complete test version, no SP1) So I take the...
0
by: adstheman | last post by:
Hi all, I am maintaining a group of applications which share Access databases. In the newer version of the software products we have upgraded from DAO to ADO and also implemented routines to...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.