Slow in design mode

[aytee111]

Some database are excruciatingly slow when making changes to a form in design mode. And if the form has a subform, going between the main form and the subform can take minutes. The database is about 300mb, not all that large, and I am forever doing a compact/repair in the hopes that it will fix it.



It is not a timing issue - i.e. a slow network at certain times - as it seems to be database related. Does anyone have any ideas?

[RuralGuy]

I would look at your printer. It can really slow down the process even though you think it should have nothing to do with it.

[aytee111]

Hmm, it's a network printer, not a lot I can do about it. I will change my default, see it that helps.

[RuralGuy]

That is exactly what you need to do. Change to a local pdf printer if you have to.

[aytee111]

Tried PDF Creator, OneNote, XPS Document writer - none of them made any difference.

Amazing that you both were so confident, it must be a known issue.

I'm thinking that maybe none of those are local, would that be it?

[RuralGuy]

Do you have a local printer? How about a Text file printer?

[aytee111]

No there are no local printers. What's a Text file printer?

Is there a way to say "no printer" in Access?

[RuralGuy]

This link should help: http://www.frogmorecs.com/arts/using...eneric-driver/

...and yes it is a known issue.

[aytee111]

Adding this printer has helped a bit, it has cut the time down between clicking to about half of what it was.

Many thanks.

[RuralGuy]

Have you checked for a Virus? It sounds like something is sucking up your CPU cycles.

[RuralGuy]

Windows can do this if it wants to update.

[aytee111]

All out of my hands and done by people over there - wherever over there is!

[RuralGuy]

IIRC, the local printer does not even need to be your default printer, just defined. Good luck.