Ms access performannce slow?

Question

we are using msaccess in early times it working fast but after huge entries it will slow down in performance. any option available for tune up ths speed.

Answer 1

This is likely to be due to a number of possible problems:

1) Poor Relational design. Did you normalize the database? If you don't know whether you did or not, you didn't. One tip-off: if you have very wide tables, you will have bad performance. This is more of a symptom of bad design than proof.

2) Incorrect keys and indexes. This could be the result of number 1 above.

3) Too much data. Access is not designed to hold more than a Gigabyte of data. Couple that with incorrectly designed and linked objects and you get totally awful performance as the data gets large.

4) It could actually be a corrupt Access system file. In that case, you can just uninstall and reinstall Access and that will solve the problems.

5) It could actually also be a corrupt database. You can fix that with the database repair tool. Make a copy of your database before doing that.

I wish you good luck with this problem.

Answer 2

You must "Compact & Repair" very often with Access (we do all ours daily!!!). This can be automated with programs like Access AutoPilot (a great product).

2. You could split the programs from the data. Make a data only database file. Link the "program access file" to the "data access file"

3. Upgrade the backend database to SQL. At our office, whenever a database gets over 10 users, or slows down, we convert it to SQL.

Also, you might need to add some indexes to speed up the searches.