August 6th, 2010, 12:02 PM
Access database size is huge due to memo field.
directly coming to the point,
Scenario:In my database, i have table questionMaster,
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.
August 6th, 2010, 12:30 PM
Re: Access database size is huge due to memo field.
Try first to zip your rich text data and then save it as binary.
Originally Posted by swaroopbhave
Click Here to Expand Forum to Full Width