Access 2007 hangs

[onikage1]

I've been using Access 2007 and I've noticed quite a bit of lag when moving around in various parts of the program.

I might be adding a field to a table and when I tab over to select a field type Access hangs, creating a form hangs, switching views in reports or queries hangs, pretty much any changes made the software hangs. Usually the computer is fine but sometimes it makes the whole system lag.

My CPU usage doesn't go above 25% but it does bounce around from 15-25 when I'm working with it and when it hangs, so I'm not really sure.

Any help would be appreciated

Thanks

[HiTechCoach]

If you have "auto name correct" turned on, it can cause a lag.


Also check out:
Microsoft Access Performance FAQ

[Mike_H]

This suggestion totally saved me from months of continued frustration with Access. I have a large database with a front/back end setup, and when another user was in, making changes to the database became very frustrating. It took upwards of 1.5 minutes to save changes to a simple form with a recordset in Access 2007. Access would simply hang on an hourglass the entire time. Disabling Auto Name Correct brought the time down to about 5 seconds. Thank you!

[HiTechCoach]

Mike,

Glad that helpful.