Access 2007: designing forms is very slow

[tadropik]

I have a simple for that has a couple of list boxes, a couple of combo boxes and a couple of sub forms.

While designing the form, it takes forever to open it and save it.

 

[boblarson]

Is the database you are working on actually on your machine or is it on a network share?

 

[tadropik]

The client resides on the local and has linked tables that reside on the network.

 

[boblarson]

Probably a network issue. I would make a copy of the backend and put it on my local machine for use while designing and relink to that. Then when time to deploy you connect it back up with the live backend.

But another possibility, which another user had, was that their default printer was set to a network printer. Not sure how that would do it but apparently for them it worked when they changed to a local printer.

 

[tadropik]

Right on Bob.

What a difference that made.

Thanks for your help.

 

[Simon_MT]

You can get the similar performance if you hold open a Table in the Back End. This table only closes on quitting the database.

Simon