Lokesh M
Profile Answers by Lokesh M Questions by Lokesh M

Nov 29th, 2011

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...