Access database size is huge due to memo field.
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: Access database size is huge due to memo field.

  1. #1
    Join Date
    Jan 2007
    Posts
    55

    Unhappy Access database size is huge due to memo field.

    Hello everyone,

    directly coming to the point,

    Scenario:In my database, i have table questionMaster,
    having fields
    Qid (pk)
    QName-memo
    Opt1-memo
    Opt2-memo
    Opt3-memo
    Opt4-memo

    using .Net, i save rich text data into questionMaster.
    The problem is it turns into huge size i.e.say for 3500 questions, database size is 900MB.
    if i zip this database, it comes to 60-70 MB only.

    Note: I have already tried compacting and repairing data utility.

    Please let me know what is the solution to reduce the size.

    i expect it to be 80 to 90 MB.

    Thanx in advance for reply.

  2. #2
    VictorN's Avatar
    VictorN is online now Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Wallisellen (ZH), Switzerland
    Posts
    17,388

    Re: Access database size is huge due to memo field.

    Quote Originally Posted by swaroopbhave View Post
    ... using .Net, i save rich text data into questionMaster.
    The problem is it turns into huge size i.e.say for 3500 questions, database size is 900MB.
    if i zip this database, it comes to 60-70 MB only
    ....
    Please let me know what is the solution to reduce the size.
    Try first to zip your rich text data and then save it as binary.
    Victor Nijegorodov

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center