Question slow loading or opening of forms and reports

[marianne]

hi people !

i was wondering why access is slow loading or opening of forms and reports when there is printing going on on the network?

what can we do about this?

 

[JANR]

Here is a link which may be of help to you.

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

JR

 

[marianne]

thanks but it doesnt say anything about printing as cause for slow opening of form or report

 

[SOS]

thanks but it doesnt say anything about printing as cause for slow opening of form or report

Actually it kind of does:

Local default printer instead of network printer

If your system is painfully slow when updating forms or reports in design view try creating a local printer and setting that as the default printer. This could be a PDF printer such as the open source PDFCreator or free CutePDF Writer. This may be more applicable to Access 2007 than previous versions. Alternatively just create a generic printer. (

2009-04-20)

The thing is that when you open a report, it is actually using the printer it is set to to be able to render. So, if you have a lot of network traffic going on to that printer then it could slow things down quite a bit.

 

[marianne]

so to conclude with, there is nothing we can do if there is a printing activity on the network?

 

[SOS]

so to conclude with, there is nothing we can do if there is a printing activity on the network?

You could set your printer for the report to be a local printer as shown in the article, but I think you should talk to your IT folks and see if they can speed up things with the printer. Perhaps there is some optimization that can occur. I don't know for sure. Maybe they aren't using a print server and could, or maybe there are some "tweaks" to one if they are.

 

[marianne]

thanks for the reply SOS. but I have no IT and my computer is LOCAL since it is attached to my CPU directly. But still my forms and report are slow on loading.

 

[SOS]

...when there is printing going on on the network...

So what is this network for which you speak? You have no IT department or IT support? This is a peer to peer network (No servers, just regular computers that are networked?)?

 

[marianne]

yes SOS. we dont use server. we are only connect via router.

 

[SOS]

yes SOS. we dont use server. we are only connect via router.

Okay, so you might have the ability to increase the speed if you open the PRINTERS > Right click on the printer and then select PROPERTIES. Then, on the SHARING tab check to see if the checkbox "Render Print Jobs on Client Computers" is checked. If not, you can try checking it. You may need to do this on each of the computers. I don't know if that option is available on XP as I have Vista, but you can check.

 

[marianne]

ok i will try that SOS. i will let you know what will happen.

 

[DCrake]

Here is an article on speeding up the opening of a form
FAQ's

David

 

[triciacallow]

This is an old string, but the problem has only just arisen when installing the database on a new server - nothing else (deliberately) changed. Why???

It's a complex form - lots of subforms and queries and drop-downs - but speed was never a problem in Access 1997, nor in Access 2007 when I first converted it. Only now, when the server and network are super-fast and up-to-date.

 

[The_Doc_Man]

tricia, there can be a gazillion reasons for this. Some questions in no particular order:

Where is Access running? On your client or on a CITRIX backend?

Did the printer queue get moved to the new server or is it on another system? (Or is it a direct-attached printer that handles its own network traffic?)

When the new server was loaded up, did anyone do a traffic analysis of the segment where the printer and server resided? (Looking for high collision rate in the physical-layer fragment.)

Switching from Ac97 to Ac2007 is a ten-year jump. At least two rounds of DLL updates have occurred and some of the routines have gotten a LOT more complex internally. There is also the fact that some defaults have changed (and changed back) since Ac97 and it is hard to remember which version defaulted to ADO vs DAO connections.

Since you are not the original poster, the information in this thread about network layout doesn't apply to you i.e. we have no idea what your network looks like. Perhaps you should start a new thread and describe your previous/current network layout.