How to improve MS Access performance?
MS Access is a relational database used to store large amount of data and overtime its performance decrease due to several reasons. However you can improve the performance of your Access database by just performing simple steps. So just try the below simple steps to improve the performance of Access database. Compact your database on a regular basis: The size of Access database grow gradually with its usage. Use Compact & Repair to reclaim unused space and to optimize the performance of your database. Make sure that each table in your database have a primary key: Having primary key in each table will allow your database to locate record easily and quickly.