Access 2007 is very slow in design view

[Amos Sobel]

I had an Access 2002 and MSSQL2005 application which was running OK untill I
did upgrade it to Access 2007. The application is generally slower but
editing forms with design view have become extremely slow:

opening a simple form with 4 subforms using Design view takes 2minuts and 10
seconds.
Evrey click of the mouse inside the open form caused a deley of 45Seconds.

This is counter productive. It does wast me working day.

Can anyone help me out of this pain?

Amos sobel

 

[Dorian]

Try putting the back end on a local drive when you are doing design changes.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Stefan Hoffmann]

hi Amos,

I had an Access 2002 and MSSQL2005 application which was running OK untill I
did upgrade it to Access 2007. The application is generally slower but
editing forms with design view have become extremely slow:
Can anyone help me out of this pain?

Hope that helps:

http://msmvps.com/blogs/access/arch...rformance-on-windows-vista-vs-windows-xp.aspx


mfG
--> stefan <--

 

[david]

Have you got Office service pack 2?

http://www.granite.ab.ca/access/performancefaq.htm

(david)