View Single Post
  #5  
Old September 5th, 2009, 01:19 AM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Birding Life List design

On Fri, 4 Sep 2009 05:22:10 -0700, CraigH
wrote:

I just did a quick look.

Major problem - change all memos that won't go over 255 characters to Text
(each entery in a memo 'I think' still takes 2k of space minimum)


18 actually (there may be a one-time 2000 byte allocation for the Memo page).
But it's still good advice, since Memos can't be indexed and are more prone to
corruption than Text fields.
--

John W. Vinson [MVP]