Report design REALLY slow

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

Hello
Got a new Laptop, HP with Core Duo CPU, 2GB Memory and 120 gb hard drive,
3/4 available space.
All is well until I start to design reports in Microsoft Access (2003). It
starts off ok when I open a report in Design View but after a few minutes of
editing and designing, it starts to slow down to an unbearable snail's pace.
I have to, not only close the report but close the whole database and
re-open it.
Please Help
Ta
 
Go to Tools, Options, General Tab and turn off Name Autocorrect on all of
your databases. IMHO it's a piece of do-do and the cause of many problems.
While there turn off Compact on Close if enabled. You'll be glad that you did.

Another thing to try is turning off the virus checker temporarily for
testing. If that speeds things up, see if you can exclude .md* files from
checking.
 
What Version of Access are you using?
You might need to update your system with the service pack from Microsoft.
Both for Vista and Office. (assuming you are using vista).

Also are you writing any VBA code used in the form? If so compile it and see
if there are any issues with it.

Andy
 
WOW!! That did it! The Auto Correct off thing. (Already had Compact on Close
off )
That's is great. Thank you!
J
 
Back
Top