Each version of Access is slower than the one before on the same hardware.
Like the cynical Wirth's law:
Software gets slower faster than hardware gets faster.
(Source:
http://en.wikipedia.org/wiki/Wirth%27s_law )
So, yes, A2007 is slower than previous versions.
Similarly, Vista is much slower that WinXP for some operations (particularly
deleting large files.) And the drivers are much less developed. When Vista
was first released, A2007 was so slow in design view, that there was almost
1 second delay in tabbing from one property to the next, and I constantly
found myself typing into the wrong property. This was largely solved when
nVidia released new drivers.
Office 2007 SP1 also addressed some performance issues. IMHO, A2007 without
SP1 is unusable - not from a performance perspective, but just unreliable.
None of my non-trivial apps would work reliably for all cases until SP1 was
released, so I would certainly not recommend it for any purpose beyond
experiementation (which was the OP's goal.) Some issues were not solved in
SP1 (e.g. assigning a specific printer to a report), but it's now quite
usable (though not hugely faster than the original release.) A major fix was
the delay when starting A2007 after using a previous version (down from 3.5
minutes to 18 seconds on my machine.)
There are other issues running Access (any version) under Vista, like
RunAsAdministrator, avoiding the virutalized folders, avoiding off-line
folders, and poor performance of intensive queries:
http://allenbrowne.com/VistaCPULoad.html
The OP was running on a laptop. As Linq Adams says, many laptops have
limited grunt, even more limited RAM, and poor graphics processing (stealing
even more system RAM.)
Suggestions:
1. Turn Aero off. You can live without the pretty translucent windows if the
laptop is more responsive.
2. Remove the "free" software that came installed on your computer.
Particuarly, the security stuff from Norton and others mean that the files
are being dragged through mud off your slow-spinning notebook drive.
3. If you have less than 2MB of RAM, consider adding more.
If you cannot do that, reduce the number of programs open at once.
You have probably already read Tony's suggestions for Access performance:
http://www.granite.ab.ca/access/performancefaq.htm
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Linq Adams via AccessMonster.com" <u28780@uwewrote in message
news:7e7844d18df8a@uwe...
One would assume a brand new machine would be reasonably fast, but it may
be
that you're getting hit with a double whammy!
I just read a paper, I think it was from ZDNet, that reported that many,
many
new laptops were simply not powerful enough to run Vista with all its
bells
and whistles. And I've seen reports from users, running various PCs, many
of
them state of the art and powerful, complaining of ACC2007 being god awful
slow in running 2000-2003 apps. What I haven't seen is anyone who's found
an
answer to the problem!
Allen Browne has been doing a lot of testing with 2007 and upgrading from
previous versions, perhaps he'll wander by and enlighten us!
Linq
