troubleshooting Question

Optmize Microsoft Access 2007, slow at time

Avatar of jana
janaFlag for United States of America asked on
.NET ProgrammingMicrosoft AccessWindows Vista
24 Comments7 Solutions405 ViewsLast Modified:
I have a DB in MS Access 2007, the size is about 112mb.  This DB is necessary for an application we have to run.  The application is developed in .NET. The PC is 2gb Ram, Vista.

The problem is that after a while, maybe 4 to 7 hours, the application get very sluggish and slow.  The application is opened in the morning, worked with the database (access) all day  and all ok, but after some hours, it just get super slow.  Sometime I exit from the application and comes back on, and it works it again.  

Questions:

1. What maintenance tasks is recommended for this database?

2. Beside the maintenance (if not the database), how can I determine if its Access, .NET or the PC

please advice.




ASKER CERTIFIED SOLUTION
CCastellanos

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 7 Answers and 24 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 7 Answers and 24 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros