You can optimise your databases without any programming....
Make sure that you compact your database at least once a week (increase the frequency of compacting if you have a high level of data exchange during a week.) When a database is compacted, fragmentation of tables over the available disk space is minimised and your queries run faster as the data becomes available on contiguous disk space
.The process of compacting has been known to fail mid-process. This could result in a corrupted file. It is advisable to compact to a new database. If you are compacting to your existing database, ensure that you have taken a backup.
You can compact your back-end database programmatically as well. But before you do this, you must detach all tables from your front-end. Then you can compact to another database using code written in a module. We have a unique utility which we use to compact as well as backup the database required.
Click here to download a sample database (28.6KB)with this great compact utility in MS-Access 2.0. (You can convert this database to the version you are using.)
| Back to MS Access Tips | Perfect Paradigm - A Solutions Company |