Archived

This topic is now archived and is closed to further replies.

Access database keep getting bigger

This topic is 5309 days old which is more than the 365 day threshold we allow for new replies. Please post a new topic.

If you intended to correct an error in the post then please contact us.

Recommended Posts

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?

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites