Access 2007 Runs Slower?

[Curtis Stevens]

I took my database that I was using with Access 2002 and it seems to run a
lot slower in 2007, which I upgrade my computer as well, so it is much faster
too. Any idea why? When going from one record to the next, it would happen
almost instantaneous in 2002, but 2007 doesn't, takes a few seconds, the
spinning busy circle shows.

 

[a a r o n . k e m p f]

wow, I've never had that problem with SQL Server.

Maybe if you kept your data in a database, instead of in a glorified
spreadsheet-- then maybe you would get enterprise-level performance.

ADP forever!

 

[Curtis Stevens]

Thanks, I think that helped, what about the hotfix, where's that?

After I applied service pack 1, this suggestion from Allen no longer works,
any idea why?


http://www.microsoft.com/office/com...ffice-access&lang=en&cr=US&sloc=en-us&m=1&p=1

 

[Curtis Stevens]

Ignore my question as it was Microsoft blocking the macro, I got it to work.

I thought it was faster, but I was wrong. Maybe the hotfix that you speak
of will work?

 

[Tony Toews [MVP]]

I took my database that I was using with Access 2002 and it seems to run a
lot slower in 2007, which I upgrade my computer as well, so it is much faster
too. Any idea why?

See the first section at Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/