By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,489 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,489 IT Pros & Developers. It's quick & easy.

Effect of Memo Field on Access File Size

P: 22
I am planning on replacing four 35-character txt fields with 1 Memo field. A Memo field can handle about 65,000 characters.

Is the Access file size based on the number of characters in each Memo field?

Or does the mere existence of a Memo field automatically increase the file size by 65,000 characters for each Record with the Memo field - even though each Memo field may be Null?
Feb 13 '12 #1

✓ answered by NeoPa

Each field has some overhead, but minimal - probably just a pointer's worth. The space taken up is relative to the space used - pretty closely I believe.

That's not to say that all space is necessarily reclaimed when it could be, but after a Compact/Repair it should reflect the space actually used.

Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,186
Each field has some overhead, but minimal - probably just a pointer's worth. The space taken up is relative to the space used - pretty closely I believe.

That's not to say that all space is necessarily reclaimed when it could be, but after a Compact/Repair it should reflect the space actually used.
Feb 13 '12 #2

Rabbit
Expert Mod 10K+
P: 12,315
What are these fields? If they contain separate data, they should remain separate. If they are separate data but related, they should go in their own table. If it's none of these, why were they separated in the first place? It should be a text field of length 140, don't use memo if you don't have to.
Feb 13 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.