Very slow report editing

[gert birkner]

hi,

when I open a report in design view an try to edit something I always have
to wait about 2-3 seconds for access to react.
Example: a field is selected and I want to select another field. This focus
shift will take 2-3 seconds. It´s nearly impossible to design a report I
have to wait everytime I change the focus or a property ...

This hapens only on this specific computer, the one at home and others are
OK.
System: WinXp SP2; Access (Office) 2003 SP 2; Pent. 4 3 GHz; 1,5 GByte RAM

Thank you in advance

gert birkner

 

[Allen Browne]

Gert, work though the list of items Tony Toews has in his:
Access Performance FAQ
at:
http://www.granite.ab.ca/access/performancefaq.htm
Things like Name AutoCorrect can make a big difference.
Just a compact/repair can also help.

If that does not solve the problem, tell us:
- Is this a replica, or partially replicated database?
- Is this report based on a crosstab query?
- Is the database on C: drive? On an external drive? Across a network?
- Does it make any difference to open the database exclusively?

 

[gert birkner]

hi Allen,

thank you for the tips, but nothing of that actualy solves my problem.

This is an Access 2003 frontend with data on the SQL Server.
The Access file is on C: the database on the network server.
no replica!
the delay of reaction starts with opening an existing or a new report in
design view (with or without databinding).
e.g. I create a new empty report without dataources. At this moment I have
to wait the first 3 seconds to be able to select a tool.
Then I insert a textfield (waiting) and add another one (waiting) and want
to select the first Textfield again (waiting) ...

There is no difference where the sql server is located (Network Server -
Local) or if the reports Datasource is filled or not. Forms don´t have this
problem.
In viewing the report (normal view) or printing it, I can´t recognize any
problems even on reports with more than 100 pages.
.... on other PCs there are no problems with the report editor.

The only difference to other PCs is: I am using to monitors.

thank you

gert birkner

 

[Allen Browne]

Okay, even if you create an unbound report (no RecordSource) in design view
(no wizard), and just add unbound text boxes to it (no combos, list boxes,
or subreports), you have a delay of several seconds when moving focus from
one text box to the other in design view?

Presumably you can reproduce this even if you create a new database, no
tables at all, and create a new unbound report in this database? If so, I
doubt this is an Access issue. It may be a problem with the computer, the
printer driver, the operating system, or with other software that is running
in the background (such as anti-virus software.)

 

[gert birkner]

Thank´s, you were right about the printer!
I changed the printer in the page settings of the report and everything went
perfect - I have to look for another printer driver for the required
printer!