Compact and repair problem (1 Viewer)

[dragnor]

Hello Experts

I'm working with a database, which take up about. 100 mb of space, after some additions of code I compiled the database and ran the compact and repair function, and then it got down to 22 mb.

I do the compile and compact and repair every day and normally it would grow in size. Can someone help me understand why it suddenly shrinks that much?

 

[boblarson]

If your operations in using the database creates a lot of space (for example doing make table queries and then deleting the tables) then that will cause the database to "bloat" until compacted. Any deletions are just marked as such and don't really get deleted until the compact and repair is run. It also can work that way while working with controls on forms, etc.