Report design REALLY slow

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
 
J

Jerry Whittle

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.
 
A

AJOLSON

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
 
J

JB

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top