.MDB file size and performance in Access 97

[jgn]

Does the size of an an mdb file affect performance in Access 97 ?

 

[JimHorton]

Not necessarily...If the size of the mdb file is large due to tables with a large amount of records, then of course, the performance will slow down a bit for access to larger tables.&nbsp;&nbsp;If the size is large due to not compacting regularly, or due to just having very many tables and objects, but the tables have a low record count, then the size of the .mdb file should not affect table access adversly--however not compacting can cause other performance issues--the indexes get rebuilt in a compact, etc.<br>--Jim&nbsp;&nbsp;