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

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".


"Amos Sobel" wrote:

> 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
>

hi Amos,

Amos Sobel wrote:
> 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/archi...indows-xp.aspx


mfG
--> stefan <--

Have you got Office service pack 2?

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

(david)

"Amos Sobel" <(E-Mail Removed)> wrote in message
news:40C682A4-DA5D-47DC-A197-(E-Mail Removed)...
>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
>