Access database runs slow

T

Tony O

I have a co-worker with an Access 2000 database that is running slow
(yes, I know Access 2000 is long out of print).

What are your recommendations for making it run faster?
 
J

John W. Vinson

I have a co-worker with an Access 2000 database that is running slow
(yes, I know Access 2000 is long out of print).

What are your recommendations for making it run faster?

Correct the problems in the database... whatever they are, which cannot be
ascertained at this distance.

Some suggestions: back up the database first and use Tools... Database
Utilities... Compact and Repair Database; analyze the tables to see if there
are appropriate indexes on the fields that are used for searching or sorting;
review the queries to see if they are appropriately designed and optimized;
make sure that there are on antivirus programs affecting the operation of the
database.

Good luck!
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 

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