Many other things cause a database to grow.
Each time you add another new form or report, more space is used. Each time you add a new control
and define some properties, even more space is used. When you define any event in a form or
report that contains even a single line of VBA code, more overhead is used, because the form or
report is no longer a lightweight object but one that is VBA-aware. This requires more space and
856
Professional Database Development Part IV
resources than a lightweight form or report containing no VBA code. If you embed images into your
forms and reports, these also will use space. Embedding bound OLE aware data, such as pictures,
sound, video, or Word or Excel documents, uses more space than unbound objects or images.
Each time that you make a change to any object??”even a simple one??”a duplicate copy of the
object is created until you compact the database. Within even a few hours of work, Access 2002
databases can begin to grow larger and larger. If the database contains thousands of lines of VBA
code, the database can grow to two or three times its original size very quickly, especially when
compiled and before it is compacted.
Pages:
1609
1610
1611
1612
1613
1614
1615
1616
1617
1618
1619
1620
1621
1622
1623
1624
1625
1626
1627
1628
1629
1630
1631
1632
1633