Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / October 2004

Tip: Looking for answers? Try searching our database.

Slow Reports and Forms too

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
garzd - 04 Oct 2004 02:19 GMT
I've been working with access 2000 profesionally now for 5 years and I've had
this problem many times and I'd like to know if anyone else has had the same
problem.  It can occur on both local drive mdb's or those located on a
network server. A report or form will become slow to open, design or save.  
It can take 2 - 3 minutes at times.  I have found that if I export the report
or form to a copy of the original mdb and then delete the report or form and
then import it back again it will work fine.  As soon as I make a change and
try to save it it can take a couple minutes for the save to take place. Once
saved the report or form will again be slow until I do the export "trick"
again.  Now over my five years I've seen this happen on many different
machines and installations of Office 2000 so it seems to me to be a "bug" in
Office.
Has anyone else experienced this.  Is there a fix available.  I am
comstantly updating many of my reports of forms and it gets very time
comsuming at times doing all this exporting and importing and waiting for 2 -
3 minute saves
Allen Browne - 04 Oct 2004 05:03 GMT
The cause is most likely Name AutoCorrect. For details, see:
   Failures caused by Name Auto-Correct
at:
   http://members.iinet.net.au/~allenbrowne/bug-03.html

If that does not solve the problem, work through the list in Tony Toews'
   Access Performance FAQ
at:
   http://www.granite.ab.ca/access/performancefaq.htm

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I've been working with access 2000 profesionally now for 5 years and I've
> had
[quoted text clipped - 20 lines]
> 2 -
> 3 minute saves
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.