What are the steps to be taken for improving performance in Microsoft Access database?

Questions by Remasri   answers by Remasri

Showing Answers 1 - 6 of 6 Answers

Few of the steps that can be taken to improve the performance of Microsoft Access Database are as follows:

Plan and Design your tables appropriately as required.
Create Normalized Tables.
Do not create redundant data.
Split your database.
Choose appropriate data types and size for fields.
Create indexes for fields where required.
Make use of Performance Analyzer to analyze tables and make necessary modifications.
Use the Data Entry command on the Records menu to avoid loading existing.
Avoid using domain aggregate functions in queries.
Retrieve and Load only the data you need.
Use dynasets updatable resultsets only when required.
In case of large tables, Make use of Data Entry mode and Snapshot type RecordsetType property
Set FailOnError Property to Yes in case of heavy query.
Avoid overlapping controls in Forms
Compact your Database
Create MDE file

There are many more...

  Was this answer useful?  Yes

anmol

  • Feb 7th, 2014
 

Compact the database when it goes morethan 50MB by using compact and repair.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions