Results 1 to 3 of 3
  1. #1
    swaroopbhave is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    2

    Red face Database size is huge due to memo fields

    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
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    Well as you probably are aware the issue is the use of the 'memo' field type. It's unlimited size feature perhaps is not needed in each field. If you can live within a 255 character field size then changing from memo to text field type will help.

    On the other hand, with huge & cheap disk drives the size of a file isn't the issue it used to be in the old days and so one could question whether this is a concern.

    corruption, images & temp tables - can add to bloat - not sure if they are relevant however.

  3. #3
    swaroopbhave is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    2

    My data size is greater than 255,and want to place data in CD

    Thanks for the reply NTS,

    As specified in title,

    1.I am storing any kind of richtext e.g. images, word tables, text.
    that is the reason i am using memo fields.

    2.i want to deploy whole setup with database in CD, as its going to be a generalized product.

    3.i have referred already developed application(got it from net)
    in that app, access database size is 74 MB, which has more questions with images than mine, and have almost same data structure as mine.
    If some body else have done it already, i thought there has to be a solution which i dont know.

    Please help me out in this.

    Thanks in advance

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 07-28-2010, 10:27 AM
  2. Database Size
    By Rick West in forum Access
    Replies: 3
    Last Post: 07-04-2010, 11:36 AM
  3. Replies: 1
    Last Post: 04-03-2010, 09:35 PM
  4. Working With Huge Databases?
    By soma in forum Access
    Replies: 2
    Last Post: 02-16-2010, 06:27 PM
  5. Database Size
    By JohnTyke in forum Access
    Replies: 4
    Last Post: 10-08-2009, 04:07 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums