Access database keep getting bigger
Author
hmm.. after filling up a database field with binary data, and then delete it, the database in itself seemes to keep the size it had when filled with data, if not more. why? can it be fixed?
quote:why?
Why not? Should it reorganize everytime you delete something? I know of no real database that autoschinks when you delete something. Cared to read the documentation?
quote:can it be fixed?
No. This behavior is intended.
You can shrink the database through a tool, though. When noone is connected. This is documented in the - documentation.
In other words the database is just as big but those cells are indeed empty so if you add stuff into the database it will go into the empty cells and the size will not increase.
~CGameProgrammer( );
~CGameProgrammer( );
Author
you''re wrong.. if u set a field to be an ole object, to add binary data to it, it increases by data put in, but stays that size after the data has been deleted. i only find this to be a problem with fields defined as ole objects and has had binary code in em, not the normal fields.
This topic is closed to new replies.
Advertisement
Popular Topics
Advertisement
