Jump to content
  • Advertisement

Archived

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

-Fruz-

Access database keep getting bigger

This topic is 5613 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
Advertisement
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
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( );

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

  • Advertisement
×

Important Information

By using GameDev.net, you agree to our community Guidelines, Terms of Use, and Privacy Policy.

We are the game development community.

Whether you are an indie, hobbyist, AAA developer, or just trying to learn, GameDev.net is the place for you to learn, share, and connect with the games industry. Learn more About Us or sign up!

Sign me up!