Re: 2000 or 2003 app slow in Access 2007 (Vista)

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@uwe> wrote in message
news:7e7844d18df8a@xxxxxx
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

.

Relevant Pages

  • Re: 2000 or 2003 app slow in Access 2007 (Vista)
    ... Software gets slower faster than hardware gets faster. ... Vista is much slower that WinXP for some operations (particularly ... The OP was running on a laptop. ... even more system RAM.) ...
    (comp.databases.ms-access)
  • Re: OT: Another Vista story regarding SP1
    ... upgrade to SP1 now and see how it goes ... I think I am going to go back to XP on my D520 laptop. ... I consider going from Vista Ultimate to XP Pro an upgrade. ...
    (alt.sys.pc-clone.dell)
  • Vists SP1 Error
    ... Trying to install Vista SP1 on a Windows Vista Home laptop [Toshiba ... It isn't my laptop. ... After seeing the Toshiba site for support, I'm ruling them out if I ever buy ...
    (microsoft.public.windows.vista.installation_setup)
  • Re: OT: Another Vista story regarding SP1
    ... upgrade to SP1 now and see how it goes ... I think I am going to go back to XP on my D520 laptop. ... I consider going from Vista Ultimate to XP Pro an upgrade. ...
    (alt.sys.pc-clone.dell)
  • Re: Vista Not Playing Nice - Sharing Files
    ... Vista Ultimate (non SP1) on desktop PC approved to run Vista. ... Vista Business on laptop approved to run Vista. ... could share files/folders between both Vista PCs. ...
    (microsoft.public.windows.vista.networking_sharing)