Access database size is huge due to memo field.

[swaroopbhave]

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.

[VictorN]

... 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.