Record-level locking cause database growth

There was an interesting discussion  in modulesdaovba newsgroup: Albert D. Kallal, Access MVP, had a very good explanation why mdb file grows so much during import - "Open databases using record-level locking" option on Options dialog Advanced tab. Read the whole thread 1GB bloat while importing

 

Technorati tags: record-level locking, database growth